topic Issue in export Data in Report Server

Issue in export Data

Anonymous — Wed, 22 Feb 2023 19:25:08 GMT

Hello,

I have a report in power BI server with a table-type visual object and I want to export to excel when exporting data only allows summary data to be exported, I get the following message:

How can I unlock the other options to export data with current or Underlying data.

Re: Issue in export Data

sevenhills — Thu, 23 Feb 2023 21:41:38 GMT

I believe you are talking Power BI .pbix report. (and not the .rdl type report). If yes, you need to change the setting. Two ways to do it

a) Using Power BI Desktop:

The link is provided here, same link in your posted image.

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-desktop

section: Admin and designer controls for exporting

In Power BI Desktop, Check the option and republish the report and see

"Allow end users to export both summarized and underlying data ... "

b) Power BI Workspace, right click the interactive report, settings, export data section, select as below:

Hope this helps!

Re: Issue in export Data

Anonymous — Tue, 28 Feb 2023 21:25:47 GMT

Hello,

Thanks for your reply but I have done this. Then I re-upload the report to power bi server but the error persists.

Re: Issue in export Data

sevenhills — Wed, 01 Mar 2023 16:53:26 GMT

These are the two options, which I am aware of.

Once you re-uploaded the report, can you check on Power BI Service?

Power BI Workspace,

right click the interactive report you re-uploaded,

settings,

export data section,

check export data is "Summarized data, data with current layout and underlying data"