Export data not an option

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.

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.

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!