Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
gman98
New Member

the "More Options" button is disabled in Power BI web (public) reports. How can i enable it?

Hello everyone, i need help with the "more options" button that suddenly disappeared from Power BI web reports, now i can't export data from it.

It is working only at desktop or workspace versions.

How can i enable it again?

thank you for your time.

best regards


2 ACCEPTED SOLUTIONS

@gman98 Publish to web does not support exporting from visuals. Publish to web from Power BI - Power BI | Microsoft Learn



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Anonymous
Not applicable

Hello,Greg_Deckler ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.


Hi,@gman98 .I am glad to help you.
I think the suggestion made by Greg_Deckler is spot on.
In fact, due to the unique nature of Publish report to web, many features would be disabled in this case.
This is due to the fact that once a report is published to the web, it becomes a transparent and open public resource, and all users have access to it.
In this particular model, data privacy protection cannot be guaranteed. Once other users can export the report data by exporting visual data, then a lot of private information of the report will be leaked. It is even possible to bypass the RLS set by the producer for the report by "publish to web".

vjtianmsft_0-1730429214828.png


These restrictions are designed to ensure data security and privacy, as well as system performance and stability.Microsoft is very concerned about protecting the privacy of user information, so these features involving sensitive information are not available in "Publish to web" mode.
If you need to export your data from the visual , I recommend you to do it in Power BI Service or share it with other users via a link.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Hello,Greg_Deckler ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.


Hi,@gman98 .I am glad to help you.
I think the suggestion made by Greg_Deckler is spot on.
In fact, due to the unique nature of Publish report to web, many features would be disabled in this case.
This is due to the fact that once a report is published to the web, it becomes a transparent and open public resource, and all users have access to it.
In this particular model, data privacy protection cannot be guaranteed. Once other users can export the report data by exporting visual data, then a lot of private information of the report will be leaked. It is even possible to bypass the RLS set by the producer for the report by "publish to web".

vjtianmsft_0-1730429214828.png


These restrictions are designed to ensure data security and privacy, as well as system performance and stability.Microsoft is very concerned about protecting the privacy of user information, so these features involving sensitive information are not available in "Publish to web" mode.
If you need to export your data from the visual , I recommend you to do it in Power BI Service or share it with other users via a link.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

Thank you for your support!

gman98
New Member

**the option gets disabled when i publish to web.

sorry

gman98
New Member

@Greg_Deckler ,

actually, when i publish to web, this option bellow gets enabled.
workspace
 More Options.png
i can't export data from a table for example, because i can't access the option.

but it happens only when I publish to web.

web
Web.png

@gman98 Publish to web does not support exporting from visuals. Publish to web from Power BI - Power BI | Microsoft Learn



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Greg_Deckler
Community Champion
Community Champion

@gman98 Are you talking about Publish to Web?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.