Forum Discussion
unable to export underlying data for Analysis Services / shared dataset / Live connection
I am encountering a problem with all visuals on all 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 the PBI Service as the source, as opposed to Azure Tabular as the source). As I understand it, behind the scenes, PBI is using Analysis Services in this architecture.
My users need to export data from visuals as both summarized data and underyling data. I have enabled this on all "model" and "report" pbix files. The summarized data export works as expected. However, the underlying data export is not working as expected; it returns just 1 row of the measures / aggregates. How do I resolve this?
I found a similar problem reported in the following post, but no solution was found:
6 Replies
- collinq
Super User
Hi Anonymous ,
TO get to the underlying data, the users will need to have "build" permissions on the dataset. Check out this link, particularly the Limitations and Considerations section:
Export data from a Power BI visualization - Power BI | Microsoft Docs
All of my reports allow all users to connect to the app's underlying datasets using the Build permission. I set this at the app level.
I just mocked up a report to test the issue. I created a small report of about 6 rows of data. I kept everything else the same (i.e., separate model and report files, publish via SharePoint / OneDrive sync). This small report exports all rows for the underyling data export option. So, maybe it's a row count issue.
