From Power Query Editor, you attempt to execute a query and receive the following error message.
Datasource.Error: Could not find file.
What are two possible causes of the error? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. You do not have permissions to the file.
B. An incorrect privacy level was used for the data source.
C. The file is locked.
D. The referenced file was moved to a new location.
Show Answer
Correct Answer: A, D
Explanation: The error 'DataSource.Error: Could not find file.' is consistent with either the query being unable to access the referenced file because it no longer exists at the specified path, or because the current user lacks access to it. An incorrect privacy level produces privacy/firewall errors rather than a file-not-found error, and a locked file typically results in a file-in-use/access error instead of 'Could not find file.'
Question 153
You need to create a visual that compares profit across 10 product categories fora selected quarter.
What is the best visual to use to achieve the goal?
A. an area chart
B. a funnel chart
C. a clustered bar chart
D. a line chart
Show Answer
Correct Answer: C
Explanation: A clustered bar chart is the best choice for comparing profit across multiple discrete product categories within a single selected quarter. Bar charts are designed for comparing values across categories, whereas area and line charts emphasize trends over time, and funnel charts show stage-based processes.
Question 154
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-wide export feature remains enabled, use the report-level 'Export data' setting. This can be configured in Power BI Desktop via the current file's Report settings before publishing, or directly in the Power BI service through the report settings. Data Load settings are unrelated to export permissions, and dataset permissions do not specifically disable export from report visuals.
Question 155
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: Use a custom format string on the measure to enforce two decimal places and display negative values in parentheses (for example, #,##0.00;(#,##0.00)). Then apply conditional formatting to the visual's font color so negative values appear in red. Setting decimal places on the visual alone does not add parentheses, and background color formatting does not meet the font color requirement.
Question 156
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 report area on a vertical (portrait) display, configure the report canvas with a custom page size by setting a custom width and height in the Canvas settings. This allows the report layout to match the portrait aspect ratio and use the available screen space efficiently. The image fit setting only affects background images, Personalize visuals is unrelated to page dimensions, and enabling the Pages pane reduces available viewing space rather than maximizing it.
Question 157
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 in feedback, Sentiment Analysis determines whether opinions are positive or negative, and Language Detection identifies the language of the text.
Question 158
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: Users need Build permission on a Power BI semantic model (dataset) to use Analyze in Excel. They do not need workspace membership if Build permission is granted directly. Providing a connected workbook alone does not grant access, RLS only filters data, and Write permission is unnecessary for analysis.
Question 159
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 explicitly states that the '&' operator is being applied to a Text value ('A') and a Number value (1). In Power Query, concatenation requires compatible types, so converting the number to text would produce 'A1'.
Question 160
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.
For the discount column, change Data Type to Decimal Number.
Select Replace Errors to replace each error value with 0.05.
Explanation: The discount values are decimal fractions, so the column should use the Decimal Number type. Then use Replace Errors on that column to keep all rows and substitute any error values with 0.05 instead of removing them.
Question 161
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: Use GENERATESERIES(start, end, step) to create a calculated table containing every integer from -100 through 100 with an increment of 1.
$19
Get all 369 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.
