Exporting Underlying Data

[pattichi]

I am currently having issues with clients being unable to export the underlying data from the reports I am sharing.

I have enabled the end user to export both summarised and underlying data from the Desktop and Service app. However, the end is having problems exporting the underlying data. Furthermore, I am having issues with exporting the underlying data also from Power Bi Service. 

I have seen other people having the same issues but no resolution that I can clearly identify and implement in my own work. 

I am wondering if there is something I am missing, causing the report to disable the export of underlying data?

[v-janeyg-msft]

@pattichi   Any updates? Have you checked the possibilities provided above?

[Burningsuit]

Hi @pattichi 

There are number of reasons you may not be able to export the underlying data in a report. From the documentation, they are :

• To export the data from a visual, you need to have Build permission for the underlying dataset.

• 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.

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

• When using DirectQuery, the maximum amount of data that Power BI can export is 16-MB uncompressed data. An unintended result may be that you export less than the maximum number of rows of 150,000. This is likely if:

  • There are too many columns. Try reducing the number of columns and exporting again.

  • There's data that is difficult to compress.

  • Other factors are at play that increase file size and decrease the number of rows Power BI can export.

• If the visualization uses data from more than one data table, and no active relationship exists for those tables in the data model, Power BI only exports data for the first table.

• Power BI custom visuals and R visuals aren't currently supported.

From your question my guess if that the user does not have Build permission on the underlying dataset, maybe just a Viewer in a Workspace.  

See Export data from a Power BI visualization - Power BI | Microsoft Docs

Hope this helps

Stuart