Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
"Export Data" Option is not appearing in the top right corner for the majority of my first page visuals. User needs to have an export to Excel option for the data.
This issue is occuring in Power BI service and not the Desktop app. The first page has multiple visuals, but none of them use data from multiple tables. The "Export Data" option also appears for me when I go into Edit view. Permissions seem to be correct, as the option is working for the second page visual and one of the visuals on the first page.
Any ideas on why most of these visuals on the first page aren't displaying the "Export Data" option? Any advice much appreciated!
Solved! Go to Solution.
I faced similar issue with Table visual. Issue is because of header Icon was 'off' for the table in Format section.
I faced similar issue with Table visual. Issue is because of header Icon was 'off' for the table in Format section.
Ensure that the "settings" on the published dashboard has "Hide the visual header in reading view" is turned off
Oh my gosh, this seemed to solve my issue. Thank you much!
CC: @safifaruqi just in case.
Thanks @dchen !! Seems like this is a enw feature, this option wasnt there last year haha. Thanks for notifying!
Facing the same issue... Export data option is not showing for table and matrix visuals in powerbi services.. for the rest of the visuals it's available. any suggestions?
Hey @dchen ,
if you can or cannot export the underlying data depends if the user has the build permission:
Build permission for shared datasets - Power BI | Microsoft Docs
The permission can be set by user individually or by AD group.
Also be aware that you can disable the export in the report itself:
So you might have to check both options.
I am havving the same issue, its not a report setting issue as its only happening on certain visuals while other visuals are working find and the user can export as needed. In the report settings, the user are 'Allowed' to export and summarize.
How can on the same report and tab, one visual displays the export/ellipses/focus mode options when one hoovers the cursor while anothe visual does not ?
Hello @safifaruqi
If it is a custom visual then you have to contact the builder and ask to allow the export option And all the visuals don't support the export data option.
IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!
Thank you for the reply.
It is not a custom visual and I can see the option to export et al. in the PBIX file just not in the webservice only for specific visuals.
Thanks for everyone's reply! I seem to be having the exact same issue as safifaruqi.
I don't think it's permissions or custom visual issue either...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.