Forum Discussion

3 Replies

  • 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"