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

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

gman98 — Thu, 31 Oct 2024 14:31:02 GMT

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

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

Greg_Deckler — Thu, 31 Oct 2024 14:54:35 GMT

gman98 Are you talking about Publish to Web?

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

gman98 — Thu, 31 Oct 2024 15:10:17 GMT

Greg_Deckler ,

actually, when i publish to web, this option bellow gets enabled.
workspace

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

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

gman98 — Thu, 31 Oct 2024 15:12:30 GMT

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

sorry

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

Greg_Deckler — Thu, 31 Oct 2024 17:30:41 GMT

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

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

Anonymous — Fri, 01 Nov 2024 02:52:31 GMT

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

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

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

gman98 — Mon, 04 Nov 2024 12:59:37 GMT

Thank you for your support!