Forum Discussion

sdegroot's avatar
sdegroot
Helper I
4 years ago

Exporting underlying data on a visual displays summarized data

Hello,

 

When selecting export underly data, some visuals in my report are succesfully providing row level info and some are showing something like the image below even though I've selected underly data (so just a summary). 

 

It does not have to do with exceeding the the max number of rows and it is not that the option for exporting underlying data is greyed out. 

 

My current guess is that it has something to do with using a shared dataset. For visuals where the measure or column were created in the foundational report/dataset, the exported data displays the underlying info, but for visuals with a measures created in the new report (but with a shared dataset), the "underly data" shows in an aggregated fashion. 

 

 

Any help would be great!

Thank you!

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi sdegroot ,

     

    If this visual uses a shared dataset, then this is relevant to the question. Please ask if the following options are set on the desktop before the shared dataset is published.

    Also, you could refer to the link below:

    Export data from a Power BI visualization

     

    Best Regards,
    Gao

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data