You have a Power BI report named ReportA.
You have a Power BI tenant that allows users to export data.
You need to ensure that consumers of ReportA cannot export any data from visuals.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. From Power BI Desktop, modify the Report settings.
B. From Power BI Desktop, modify the Data Load settings.
C. From the Power BI service, modify the dataset permissions.
D. From the Power BI service, modify the Report settings.
Show Answer
Correct Answer: A, D
Explanation: To prevent consumers from exporting data from visuals while the tenant allows export, you must disable export at the report level. This can be done either in Power BI Desktop (File > Options and settings > Options > Current file > Report settings > Export data) before publishing, or directly in the Power BI service via the report’s settings. Dataset permissions and data load settings do not control visual-level export behavior.
Question 151
You have a Power BI report that contains a visual. The visual contains a measure.
You need to ensure that the report meets the following requirements:
• All values must be set to two decimal places.
• All negative values must be displayed in red font and parentheses.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. For the visual, apply conditional formatting to the background color.
B. Configure the measure to use a custom format.
C. For the visual, apply conditional formatting to the font color.
D. For the visual, set Value decimal places to 2.
Show Answer
Correct Answer: B, C
Explanation: Two requirements must be met: formatting and color. A custom measure format can enforce two decimal places and display negative numbers in parentheses. Conditional formatting on the visual’s font color is required to render negative values in red. Setting decimal places on the visual alone cannot apply parentheses, and background color is not requested.
Question 152
You have a Power BI report that will be rendered on a vertical display.
You need to maximize the portion of the screen area used by the report.
What should you do?
A. From the Canvas background setting of Power BI Desktop, configure the Image fit setting.
B. From the Canvas settings of Power BI Desktop, set a custom width and height.
C. From Power BI Desktop, select Personalize visuals.
D. From the Power BI service, enable the Pages pane.
Show Answer
Correct Answer: B
Explanation: To maximize the usable screen area on a vertical display, you must adjust the report canvas dimensions to match the display’s portrait orientation. In Power BI Desktop, setting a custom width and height in Canvas settings allows the report page to fill the vertical screen efficiently. The other options do not change the report canvas size or orientation.
Question 153
DRAG DROP
-
You need to use AI insights to add a column of enhanced data based on the customer feedback. The solution must identify the following:
• What the customers most often provide feedback about
• Whether the customers like your company’s product
• The language of the feedback
Which AI insights service should you use for each output? To answer, drag the appropriate services to the correct outputs. Each service 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 is worth one point.
Show Answer
Correct Answer: What the customers most often provide feedback about:
Key Phrase Extraction
Whether the customers like your company’s product:
Sentiment Analysis
The language of the feedback:
Language Detection
Explanation: Key Phrase Extraction identifies the main topics repeatedly mentioned in feedback. Sentiment Analysis determines whether opinions are positive, negative, or neutral, indicating if customers like the product. Language Detection identifies the language in which the feedback is written.
Question 154
You have a Power BI dataset named Finance that is hosted in a Power BI workspace.
The finance team at your company is NOT currently a member of any Power BI workspace roles.
You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset.
What should you do?
A. Grant the finance team build permissions to the Finance dataset.
B. Provide an Excel workbook that is connected to the Finance dataset.
C. Create a row-level security (RLS) role and add the finance team to the role as members.
D. Grant the finance team write permissions to the Finance dataset.
Show Answer
Correct Answer: A
Explanation: To analyze a Power BI dataset from Microsoft Excel (Analyze in Excel or live connection), users must have Build permission on the dataset. Build permission allows connecting from Excel without requiring workspace membership. Providing an Excel workbook alone does not bypass permissions, RLS is unrelated to enabling Excel access, and Write permission is unnecessary and excessive.
Question 155
HOTSPOT
-
You attempt to use Power Query Editor to create a custom column and receive the error message 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.
Show Answer
Correct Answer: mismatched data types
A1
Explanation: The error message states that the '&' operator cannot be applied to Text and Number, indicating mismatched data types. The intended operation is to concatenate the text 'A' with the number 1, producing the text result 'A1' once both values are treated as text.
Question 156
DRAG DROP
-
You use Power Query Editor to preview the data shown in the following exhibit.
You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort.
Which three 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.
Show Answer
Correct Answer: Select the discount column.
Select Replace Errors to replace each error value with 0.05.
For the discount column, change Data Type to Decimal Number.
Explanation: Replacing errors first preserves all rows and ensures valid numeric values. Converting the column to Decimal afterward avoids type-conversion failures and minimizes cleanup steps.
Question 157
HOTSPOT
-
You are creating a Power BI model in Power BI Desktop.
You need to create a calculated table named Numbers that will contain all the integers from -100 to 100.
How should you complete the DAX calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: GENERATESERIES
(-100, 100, 1)
Explanation: GENERATESERIES creates a single-column table of numbers from a start value to an end value using a specified increment. Using -100 to 100 with a step of 1 returns all integers in that range.
Question 159
DRAG DROP
-
You have the Power BI data model shown in the following exhibit.
The Country table contains the following data.
You create two row-level security (RLS) roles named Manager and CFO.
You plan to publish the dataset to the Power BI service.
You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:
• Each manager must see only the data in the Sales and Human Resources tables for their own country.
• The CFO must be prevented from seeing the data in the Human Resources table.
• The CFO must see the sales data of all countries.
How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression 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 is worth one point.
Explanation: The Country table is filtered by the logged-in user’s email so managers only see data for their own country, and this filter propagates to Sales and Human Resources through relationships. For the CFO role, filtering the Human Resources table with a condition that does not grant access to other managers’ rows effectively prevents visibility of HR data, while leaving Sales unfiltered so the CFO can see sales for all countries.
Question 160
HOTSPOT
-
You have the Azure SQL databases shown in the following table.
You plan to build a single PBIX file to meet the following requirements:
• Data must be consumed from the database that corresponds to each stage of the development lifecycle.
• Power BI deployment pipelines must NOT be used.
• The solution must minimize administrative effort.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Create:
One parameter
Parameter type:
Text
Explanation: All environments differ only by the stage suffix (dev/uat/prod) shared by both server URL and database name. A single Text parameter (e.g., dev, uat, prod) can be concatenated in Power Query to construct both values dynamically, enabling one PBIX to switch environments with minimal administration and without deployment pipelines.
$19
Get all 356 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.
