Absolute Free PL-300 Exam Practice for Comprehensive Preparation 

You have the CSV file shown in the following table.

You use Power Query Editor to preview the data in the file. You need to transform the data to meet the following requirements: • The first column must contain the month. • The second column must contain the year. • The third column must contain the order amount for the month and year. Which transformation should you use first? 

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives? 

You embed a Power BI report in a Microsoft SharePoint Online page.

A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following

error message: “This content isn’t available”.

User1 is unable to view the report.

You verify that you can access the SharePoint Online page and that the Power BI report displays as expected.

You need to ensure that User1 can view the report form SharePoint Online.

What should you do?

You have an app workspace named Retail Analysis in the Power BI service. You need manage the members that have access to the app workspace. What should you do?

You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power Bi dataset You need to ensure that the dataset can be refreshed in powefbi.com. Which two connectors can you use to connect to the file? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point