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.

sbm's avatar
sbm
Helper II
5 years ago

Hi Anonymous 

 

Thank you for your response to this. Here is the detail below.

 

 

1. Did it occur to any files? - I tried it on two PBI report in service. I got the same issue that only able to export the total values not all the rows from underlying data. However, I am an admin to that workspace but not the Power BI Administrator. is this option disabled by default in the Power BI tenant setting and need to enable to use this feature?

 

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

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

 

Also have a look at the limitations and considerations:

Export using Underlying data won't work if:

 

  • the version is older than 2016. not older than 2016

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

  • an administrator or report designer has disabled this feature. - not sure

 

Thank you,

Regards

SBM