You are creating a new semantic model in Microsoft Power Bl Desktop.
You connect to a recently used data source and receive an error message indicating that the password is expired.
You need to update the credentials for the data source.
What should you do?
You use Power Query Editor to Import three tables named Customers. Address, and Country.
In the source system, not every customer has a related address, but every address has a related country.
You need to merge all the tables into a single query. The solution must optimise query refresh performance.
Which type of join should you use for each merge operation? To answer, drag the appropriate join types to the correct operations. Each join type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection it worth one point.
You have a Power B1 dataset named Finance that is hosted in a Power B1 workspace.
The finance team at your company is NOT currently a member of any Power B1 workspace roles.
You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset.
What should you do?
You are using Power Bi Desktop to connect to an Azure SQL database The connection is configured as 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 solution is worth one point
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
From Power Query Editor, you profile the data shown in the following exhibit.
The IoT GUID and IoT ID columns are unique to each row in query.
You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You remove the loT GUID column and retain the loT ID column.
Does this meet the goal?
You need to create a Power Bl report. The first page or the report must contain the following two views:
* Sales By Postal Code
* Sales by Month
Both views must display a slicer to select a value for a field named Chain.
The Sales By Postal Code view must display a map visual as shown in the following exhibit.
You have the Power BI data model 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.
You have a Power BI semantic model that contains a table named Table1. Table1 contains the following columns:
* WebsiteName
* URL
You need to create a report named Report1 that will contain a table visual. The solution must meet the following requirements.
* Display the website name
* Enable users to navigate to the website’s URL by selecting the website name.
What should you use?
You have a Power Bl report hosted on powerbi.com that displays expenses by department for department managers.
The report contains a line chart that shows expenses by month.
You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort.
What should you do?
You have two Power Bl reports named ReportA and ReportB that each uses a distinct color palette.
You are creating a Power Bl dashboard that will include two visuals from each report
You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
TESTED 16 Nov 2025
