"Export Data" Option is missing from Reading View

[dchen]

"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! 

[bipinp · Accepted solution]

I faced similar issue with Table visual. Issue is because of header Icon was 'off' for the table in Format section.

[RTK]

Ensure that the "settings" on the published dashboard has "Hide the visual header in reading view" is turned off

[dchen]

Oh my gosh, this seemed to solve my issue. Thank you much! 

CC: @safifaruqi just in case.

[safifaruqi]

Thanks @dchen !! Seems like this is a enw feature, this option wasnt there last year haha. Thanks for notifying! 

[rama_pitchai]

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?

[selimovd]

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.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[safifaruqi]

@selimovd 

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 ?

[safifaruqi]

@selimovd  also this only happen in webservice and not the PBIX

[NimaiAhluwalia]

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!

[safifaruqi]

Hi @NimaiAhluwalia  

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. 

[dchen]

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...

[safifaruqi]

@dchen  Seems like we might have to log a ticket with microsoft 

[dchen]

@safifaruqi Hi! Out of curiousity, did Microsoft end up resolving your ticket?

[safifaruqi]

@dchen no my friend nothing. I am still trying to figure it out but no luck.