You need to create a visualization to meet the reporting requirements of the sales managers.
HOW Should create the Visualization? TO answer, select the appropriate options in the answer area.
You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.
You need to add a new column that contains the data in the format of nnn-nnn-nnnn.
How should you complete the Query Editor formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
For the sales department at your company, you publish a Power Bl report and a semantic model that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder. The semantic model contains several measures.
You need to create a new Power Bl report from the existing data that will use many of the measures created in the initial Power Bl semantic model. The solution must minimize development effort.
Which type of data source should you use?
You have a source that contains a comumn. The column contains case sensitive date. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue.
Solution: You change the semantic model mode.
Does this meet the goal?
You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)
Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.
You need to keep only the last modified row for each customer ID.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
