Forum Discussion
how to export underlying data when using Live connection to a dataset
I am encountering a problem with all visuals on all Power BI (PBI) reports. I use a "shared dataset" architecture. That is, several reports will source from a single dataset. This is achieved by a Live connection (with a dataset in the PBI Service as the source, as opposed to Azure Tabular as the source). If it matters, for this particular situation, the PBI Service puts the dataset into Analysis Services.
My users need to export the underlying data from all visuals. I have enabled this option on all "model" and "report" pbix files. Also, I have enabled the Build permission on all reports (at the app level). However, when a user selects Export data \ Underlying data, it returns just 1 row of the measures / aggregates. It's not even slicing it by the dimensions as with Export data \ Summarized data (i.e., "Underlying data" is less granular than "Summarized data", which is backwards). How do I resolve this?
Hi, Anonymous
Make sure to enable the export of underlying data sets in the desktop settings,Then check whether the export of xlsx files is enabled in the portal settings.
When exporting the visual object data, select the underlying dataset, or use the analysis in Excel to export the underlying data.
refer:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
I just learned that there is a governing issue in some (but not all) of my apps. Per the following link, it seems that, when the 'Entire organization' option is selected for Permissions during app publication, this blocks the Build permission on all datasets in the app. However, this doesn't explain why this issue is present in apps that don't have this Permission option.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-share
- v-angzheng-msft
Community Support
Hi, Anonymous
Make sure to enable the export of underlying data sets in the desktop settings,Then check whether the export of xlsx files is enabled in the portal settings.
When exporting the visual object data, select the underlying dataset, or use the analysis in Excel to export the underlying data.
refer:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.