Power bi Export data

[Anonymous]

Hello @amitchandak 

My requirement is, after publishing the report on website i want to publicly availabe data and user should get selected visuals data in excel file by the clicking on "Export data" button beacause it's not possible to give the access those many users on Power BI service and we cannot share the pbix file to these many users. So anyone has solution on this?

[Iryna_Bindas]

Hello,

I have a question regarding non-premium Power BI users. They seem to not be able to export the data from the Dashboard to Excel (they don't have this option in the Dashboard). And so question is if there is any way to share the Dashboard with the people who do not have Power BI license and give them an option to export the data from the Dashboard.

Thanks!

[amitchandak · Accepted solution]

@Anonymous , Every visual has an export data option. Another way is to create a power automate flow.

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-desktop

Publish to web

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web#find-your-power-bi-administrator

also refer

https://www.datatobiz.com/blog/export-power-bi-dashboards-using-power-automate/

https://www.youtube.com/watch?v=wy1BE1TJ_jc