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 repor...
Need Help
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.