I have an issue with extracting underlying data, it was enabled before, but now it only gives me the option to export the summarized data and not the underlying one. I researched a lot and everything seems fine to me in my settings. please help.
Go to Solution.
You need to enable build permissions on the dataset for the users who need to extract the underlying data.
For more limitations, please refer to https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
View solution in original post
Appreciate your support as I am struggling with preparing my reports.
I assume you already had a look at the Power BI Tenant settings for Export Data and Export to Excel?
Also have a look at the limitations and considerations:
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.
Proud to be a Super User!
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.