Export data not an option

[Anne_PBI]

Hi, 

I've created a report en published it to PBI service. However, when I want to get an excel dump of a table, the export data option is not available. Other reports (also created by me) in the same workspace do have this option. 

I've checked the following:

In PBI desktop > settings > the option for end users  to export data is turned on:

The tenant settings for export data are turned on:

In PBI service > settings of the report > I've specified what users are allowed to export:

But in the report online, no export data option:

Does anyone have an idea what can be the cause of this and how to solve it?

Many thanks, Anne

[Poojara_D12 · Accepted solution]

Hi @Anne_PBI 

You've encountered a frustrating issue in Power BI: the "Export data" option is missing for a specific report you published, even though all the relevant settings appear to be correctly configured. This is preventing you from getting an Excel dump of a table within that report, a functionality that works for your other reports in the same workspace. You've diligently checked the settings in Power BI Desktop, the tenant settings for data export, and the report-specific settings in the Power BI service, confirming that data export should be enabled for the report and its users. Despite this, the export option remains stubbornly absent in the online version of the report. This discrepancy suggests a potential conflict or issue beyond the basic settings. Possible causes could include specific configurations within the report itself (like row-level security or specific visual settings), a temporary glitch in the Power BI service, a browser-related issue (cache, extensions), or a problem with the dataset connection. Troubleshooting steps might involve republishing the report, testing in a different browser, examining the report's data model for any unusual security rules, and checking the data source connection for any potential errors.

[v-ssriganesh · Accepted solution]

Hi @Anne_PBI,
Thanks for posting your query in Microsoft fabric community forum.

I want to thank @Poojara_D12 for the detailed and helpful response. Great insights were shared. Building on those suggestions, I’d like to add a few additional points that might help narrow down the cause of the missing Export Data option in your report:

• Navigate to the report settings in Power BI Service. Under Visual Options, make sure that "Show visual header in reading view" is enabled. This will allow users to view the ellipsis menu (… icon) on visuals, where the Export Data option is located.

• In Power BI Service, go to the dataset > Manage Permissions. Ensure that the relevant users/groups have at least Read and Build permissions.

• If the dataset uses Direct Query, and the visual is complex (e.g., involving custom measures), Exporting Underlying Data may be blocked. Some live connections (e.g., Analysis Services) also restrict detailed data export based on the underlying model’s permissions.
• Sometimes, certain visuals (like custom visuals or composite visuals) do not support exporting data. Create a simple Table or Matrix visual with the same data. Check if the Export Data option appears there.
  
  

Here’s a helpful Microsoft documentation link on export settings in Power BI:
Export Data from a Visualization

If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Hope this works for you!

Thank you.

[v-ssriganesh]

Hello @Anne_PBI,

Could you please confirm if your query have been resolved? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.

Thank you.

[v-ssriganesh]

Hi @Anne_PBI,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh · Accepted solution]

Hi @Anne_PBI,
Thanks for posting your query in Microsoft fabric community forum.

I want to thank @Poojara_D12 for the detailed and helpful response. Great insights were shared. Building on those suggestions, I’d like to add a few additional points that might help narrow down the cause of the missing Export Data option in your report:

• Navigate to the report settings in Power BI Service. Under Visual Options, make sure that "Show visual header in reading view" is enabled. This will allow users to view the ellipsis menu (… icon) on visuals, where the Export Data option is located.

• In Power BI Service, go to the dataset > Manage Permissions. Ensure that the relevant users/groups have at least Read and Build permissions.

• If the dataset uses Direct Query, and the visual is complex (e.g., involving custom measures), Exporting Underlying Data may be blocked. Some live connections (e.g., Analysis Services) also restrict detailed data export based on the underlying model’s permissions.
• Sometimes, certain visuals (like custom visuals or composite visuals) do not support exporting data. Create a simple Table or Matrix visual with the same data. Check if the Export Data option appears there.
  
  

Here’s a helpful Microsoft documentation link on export settings in Power BI:
Export Data from a Visualization

If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Hope this works for you!

Thank you.

[Anne_PBI · Accepted solution]

Thank you for your suggestions @v-ssriganesh and @Poojara_D12. I've tried them all and in the end the only solution was to rebuild all tables and matrixes in a different (clean/new) report and then copy them to my report. I still do not understand what the issues was but now I can download the data... very strange.

Many thanks!

[v-ssriganesh]

Hi @Anne_PBI,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Poojara_D12]

Hi @v-ssriganesh 

Thanks for the kind words.

If possible, please visit my Youtube channel, I upload videos around Power BI, SQL and related things, it will be really helpful and gives motivation to work more on that.

The link is given below of my channel.

[Poojara_D12 · Accepted solution]

Hi @Anne_PBI 

You've encountered a frustrating issue in Power BI: the "Export data" option is missing for a specific report you published, even though all the relevant settings appear to be correctly configured. This is preventing you from getting an Excel dump of a table within that report, a functionality that works for your other reports in the same workspace. You've diligently checked the settings in Power BI Desktop, the tenant settings for data export, and the report-specific settings in the Power BI service, confirming that data export should be enabled for the report and its users. Despite this, the export option remains stubbornly absent in the online version of the report. This discrepancy suggests a potential conflict or issue beyond the basic settings. Possible causes could include specific configurations within the report itself (like row-level security or specific visual settings), a temporary glitch in the Power BI service, a browser-related issue (cache, extensions), or a problem with the dataset connection. Troubleshooting steps might involve republishing the report, testing in a different browser, examining the report's data model for any unusual security rules, and checking the data source connection for any potential errors.