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?

Question

Accepted Answer

B. For the report change the Export data setting to Summarized data, data with current layout and Changing the "Export data" setting for the report to allow "Summarized data, data with current layout and" is necessary for users to export underlying data or connect to the dataset via Analyze in Excel. The "Build" permission enables users to create new content from the dataset, and this setting controls the granularity of data they can access for export or direct connection.

Answer

A. Change default visual interaction for the report 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.

Answer

C. For the report, change the Export data setting to None 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.

Answer

D. Certify the dataset used by the report. 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.

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…

Question

Options

How the community answered

Why each option

Community Discussion