Forum Discussion

sevenhills's avatar
sevenhills
Super User
3 years ago

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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello,

     

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

    • sevenhills's avatar
      sevenhills
      Super User
      3 years ago

      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"