PL-300 Question #263: Real Exam Question with Answer & Explanation

Question

You have a BI dataset and a connected report. You need to ensure that users can analyze data in Microsoft Excel by connecting directly to the dataset. You grant the users the Build permission for dataset What Should do next?

Options

• AChange default visual interaction for the report
• BFor the report change the Export data setting to Summarized data, data with current layout and
• CFor the report, change the Export data setting to None
• DCertify the dataset used by the report.

Explanation

To allow users to analyze Power BI dataset data directly in Excel, after granting Build permission, you must ensure the report's export data settings permit this action.

Common mistakes.

• A. Changing default visual interaction for the report affects how visuals interact within the report itself, not how users connect to the dataset externally via Excel.
• C. Changing the "Export data" setting to "None" would prevent users from exporting any data from the report, directly counteracting the goal of analyzing data in Excel.
• D. Certifying the dataset enhances its discoverability and trust within the organization but does not directly enable or disable the ability for users with Build permission to connect to it via Excel.

Concept tested. Power BI Analyze in Excel and export settings

Reference. https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

No community discussion yet for this question.