CODEWITHSUNDEEP
powerbi
skyline01
skyline01

Reputation: 2101

how to export underlying data in Power BI report for live connection

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?

Upvotes: 0

Views: 1355

Answers (2)

the-a-monir
the-a-monir

Reputation: 177

Have you tried this: In Power BI Desktop, select

File > Options and Settings > Options > Current File > Report Settings
> Export Data subtitle > “Allow End Users to Export Both Summarized and 
Underlying Data from the Service.”

Upvotes: 0

TeflonMusk
TeflonMusk

Reputation: 150

You need to enable build permission on the dataset, not just the report.

Let me know if this answers your question.

Upvotes: 0

Related Questions