You don't have permission to export underlying data

[Anonymous]

Hi, I create a dataset using import option from the SQL Database. I want to export all the rows used to make a table visualization, and export underlying data option is disabled and says that (You don't have permission to export underlying data), and when I export the data using the summarized data option it doesn't give me all the rows.

What is the solution
could it be related to the database permission? 

[Anonymous · Accepted solution]

I select Allow end users to export both summarized and underlying data from the service option from the Power BI desktop and it solved my problem.

https://docs.microsoft.com/sv-se/power-bi/visuals/power-bi-visualization-export-data

[Mrab]

Thank you.

[Anonymous]

Hi, This issue is not related to Database Permission. It's related to the information you are having in the visual you are trying to export data from.

I am sure this link can help: https://community.powerbi.com/t5/EdX-Specific-Training-Discussion/Export-data-underlying-data-not-av...