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?
Change default visual interaction for the report
For the report change the Export data setting to Summarized data, data with current layout and underlying data
For the report, change the Export data setting to None
Certify the dataset used by the report.
Submit