For the sales department at your company, you publish a Power Bl report and a semantic model that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder. The semantic model contains several measures.
You need to create a new Power Bl report from the existing data that will use many of the measures created in the initial Power Bl semantic model. The solution must minimize development effort.
Which type of data source should you use?
You have a Power BI report that contains a page. The page contains the following visuals:
• A card
• A matrix
• A bar chart
You need to configure the page to ensure that the card and the bar chart are unaffected when a user drills down in the matrix The card and the bar chart must change when a user selects a cell in the matrix.
What should you configure? To answer, select the appropriate options in the answer area.
You are using Microsoft Power Bl Desktop to profile data in Power Query Editor. Table data is displayed 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 selection is worth one point.
You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.
You need to create a Power BI report that connects to the project management app.
Which connector should you select?
You are profiting data by using Power Query Editor.
You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.
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 ID columns are unique to each row in query.
You need to analyze 10T events by the hour and day of the year. The solution must improve dataset performance.
Solution: You change the IOT DateTime column to the Date data type.
Does this meet the goal?
For the sales department at your company, you publish a Power Bl report that imports data from a Microsoft Excel We located in a Microsoft SharePoint folder The data model contains several measures You need to create a Power Bl report from the existing data. The solution must minimize development effort. Which type ol data source should you use?
You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit.
Which type of visual should you use?
You need to address the data concerns before creating the data model. What should you do in Power Query Editor?
You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?
TESTED 17 Aug 2025
