Forum Discussion

sbm's avatar
sbm
Helper II
5 years ago
Solved

Export to Excel - Underlying Data

Hi All, I'm exporting data using "underlying data" from a visual in Power BI Service which should remove the aggregation If a visual has aggregates but in my case, it exports only total to excel. ca...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi sbm ,

     

    Based on your description, please refer to this link.

    It will only export the relevant underlying data to excel.

    My test:

    My table visual:

    Export to Excel:

     

    Or did you add any filters to this report?

     

    If none of the above suggestions solve the problem, it may be caused by transient service mental disorder syndrome. It is difficult (if not impossible) to troubleshoot. I have tried my best to troubleshoot it. So I suggest you file a support ticket here.

     

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

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

    It helps me a lot. Thank You!

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi sbm ,

 

Have you selected the option "Allow users to export underlying data" as follows in Power BI Desktop?

 

Best Regards,

Yuna

 

sbm's avatar
sbm
Helper II
5 years ago

Hi Anonymous , yes, I already have enabled this option, so that end users can export both summarized and underlying data.

When I trying to export underlying data from a report based on a single table. It works fine but when I tried from the reports based on dim tables and facts table(Star Schema) with 1 to many relationships, it only exports the total values in an excel file. is there still anything, I'm missing in setups?

 

Thanks again,

 

Regards

SBM