Microsoft PL-300 - Microsoft Power BI Data Analyst
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.
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.
You have a Microsoft Excel file on a file server.
You create a Power BI report and import a table from the Excel file.
You publish the report.
You need to ensure that the data refreshes every four hours.
What should you do first?
You create a Power Bl dataset that contains the table shown in the following exhibit.
You need to make the table available as an organizational data type In Microsoft Excel.
How should you configure the properties of the table? To answer select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to address the data concerns before creating the data model. What should you do in Power Query Editor?
You publish the semantic model to powerbi.com.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?
You need to provide a solution to provide the sales managers with the required access.
What should you include in the solution?
You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection'
You publish the dataset to powerbi.com.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
What should you create to meet the reporting requirements of the sales department?