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 ,

 

Based on your description, can you give me more details?

 

1. Did it occur to any files?

2. Can you successfully export underlying data to excel using another account?

3. I assume you already had a look at the Power BI Tenant settings for Export Data and Export to Excel?

Also have a look at the limitations and considerations:

Export using Underlying data won't work if:

 

  • the version is older than 2016.

  • the tables in the model don't have a unique key.

  • an administrator or report designer has disabled this feature.

 

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.