Microsoft PL-300 Exam Real Questions

The Sales table contains records of sales by day from the last five years up until today's date.

You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected.

Which DAX expression should you use?

You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection' 

You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization. You need to ensure that the users will see the current data when they view the dashboard. How should you configure the connection to the data source?

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

You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege. Which role should you assign to the user?