Allowing public users to download data (excel) - Power BI

[Anonymous]

Hello, Is there now possibility of exporting data (excel) from a published Power BI dashboard for external, public users who are not Power BI users? (Without specific user invitation). As far as I know, it was not possible in 2022.

Thanks in advance

[Anonymous]

Hello, As far as I know, Power automate export needs per user license. Are you sure, It will work is case of anonimous, guest users?

[PijushRoy]

Hi @Anonymous 

If you are Embeded report in Public (Publish to Web), the export from visual option is not available
Please check out below link in Limitation section
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[Anonymous]

Thank you for your attention. Let me clarify. I have publicly published Power BI Dashboard and I want everyone (including all external, public users, who are not Power BI users too) Without specific individual user invitation to be able to download data to Excel. Does Power BI currently allow this?
Thanks

[PijushRoy]

Hi @Anonymous 

No, the Export option is not available when you publish report in the Public

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[Anonymous]

Thank you very much for your answer. Is there any workaround?

Thanks.

[PijushRoy]

Hi @Anonymous 

Please try the Power Automate export button in Power BI
https://www.youtube.com/watch?v=BnTipbooeP0

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin