You plan to develop a Power BI report that has a bar chart to display the number of customers by location. You have a table named Customer that has the following columns:
• Customer ID
• CustomerName
• Address
• City
• ProvState
• Country
You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City. How should you configure the drill down in the bar chart?
You plan to create a report that will display sales data from the last year for multiple regions
You need to restrict access to individual rows of the data on a per region-basis by using roles.
Which four 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 Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 custom visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report
You need to recommend a solution to improve the performance of the report.
What should you recommend?
You have a semantic model.
You need to configure row level security (RLS) to restrict data access for users that have the Viewer permissions.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to tie answer area and arrange them in the correct order.
UESTION NO: 7
You have a report that contains a bar chart and a column chart. The bar chart shows customer count by
customer segment. The column chart shows sales by month.
You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.
How should the visual interactions be set on the column chart when the bar chart is selected?
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 Normalize casing in the source query or Power Query Editor.
Does this meet the goal?
You have a Power Bl semantic model that contains the following tables.
All the tables use the same data source.
You need to reduce the number of limited relationships in the model by changing the storage mode of certain tables. The solution must NOT affect the latency of the data.
Which storage mode should you select for the Customer and Geography tables? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You are creating a Power Bl report by using Power Bi Desktop.
You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals.
Which type of visual should you use?
What should you create to meet the reporting requirements of the sales department?
You have a semantic model that contains a table named Sales. The table contains the following columns;
• Order ID
• Product ID
• Sales Dote
• Sales Amount
You need to create a DAX measure that will return the total sales amount for the same dates from the previous year. How should you complete the measure? To answer, select the appropriate options m the answer area.
NOTE: Each correct selection is worth one point.
TESTED 15 Jun 2025
