Question 81

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.
You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.
What should you do?
  • Question 82

    You are profiling data by using Power Query Editor.
    You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is shown in the following exhibit.

    Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
    NOTE: Each correct selection is worth one point.

    Question 83

    You need to grant access to the business unit analysts.
    What should you configure? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 84

    You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server.
    You need to ensure that all the visualization in the report can be consumed by users.
    Which two types of visualizations should you exclude from the report? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.
  • Question 85

    You need to create a measure that will return the percentage of late orders.
    How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.