Export underlying data to Excel

The ‘underlying data’ export to excel from Power BI service is giving only an empty excel spreadsheet even if I allowed users to export both summarised and underlying data.why is this happening? The summarised data option is working as expected.

I believe that’s the security options to prevent export of underlying data on admin settings

@williamnt That was also my initial thinking but that is enabled to the ‘entire organization’ and that should be good enough to export the underlying data.

have you check current file report settings?

@williamnt yes I did check the report setting for the current file but nothing special.

Out of curiosity, is there a column thats “Blank” in the data? Even just the column header.

Hello @jojo,

Thank You for posting your query onto the Forum.

Have you checked this documentation from the Microsoft on the topic “Export the data that was used to create a visualization”.

Thanks & Warm Regards,
Harsh

1 Like

Hi @jojo, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!

no there are no blanks

Hello @Harsh,

The most important idea I get from this MSFT documentation is that if the data is classified as “confidential” then it may not be possible to export it, that might be the case with my issue. The problem is it should have provided some options at least for the admin if not for the users.

Thank you

Hello @jojo,

You’re Welcome. :slightly_smiling_face:

I’m glad I was able to help you.

Well my guess was also on this topic " Protect data when it is exported out of Power BI as well as some of the points mentioned under the limitations which are -

  1. To export the data from a visual, you need to have Build permission for the underlying dataset(https://docs.microsoft.com/en-us/power-bi/service-datasets-build-permissions).

  2. Export using Underlying data won’t work if you enable the Show items with no data option for the visualization Power BI is exporting.

  3. Power BI admins can disable the export of data.

Thanks & Warm Regards,
Harsh