Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Underlying data is selectable in reports but only get Summarized data

Hi 

 

What am I doing wrong, I can select export data underlying data, but when i do that i only get a file with summarized data.

there must be a setting I have missed.

 

I am admin in the report and dataset

Need Help

2 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

     

    Try selecting Allow export of underlying and summarized data sources in the data source setting in powerbi desktop. Then republish to the service and export again.

     

     

    Also, you can read below blog for more details.

    How To Export Underlying Data in Power BI (designmind.com)


    If the problem is still not resolved, please provide detailed error information and related screenshoots. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi v-henryk-mstf 

       

       

      Allow end users tro export data with current layout, summarized data and underlying data from the service or report server.

      Is selected and published.

      select the visualization, and select export

      select underlying data

      excel file is downloaded, when I open it, I only get the Summarized data, in the excel file, I have checked there not is more than one sheet.