Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to download data from a published public embedded report?

I have a public report published on the web using power bi service. How can I download/export a table on that report into a CSV/Excel file?


I changed the export settings to download summarized and underlying data


This link talks about sharing it with specific people but that is not my requirement. 


This forum has been amazing for me but no one really seems to have an answer for this. Any help is appreciated.

Helper II
Helper II



          It is not possible to download data from Power BI service. You have to download .pbix file and export data in the Power BI desktop.




Community Support
Community Support

Hi, @anansrivastava 


If you open the public link to view the report, the report data cannot be exported
If the user is the owner of the report or the user has access to the workspace where the report is located, or the recipient opens the report through a sharing link within the organization, you can use the Analyze in Excel to export the underlying data.




Hope this helps.


Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



Frequent Visitor

Hi @anansrivastava ,


please go through the below link will usefull.


Thank you very Much

Hi @rakesh_js 

Thank you but that is not what I am looking for. I have been through that link before. What I would request for is a hack/solution to downloading data from published reports.

Helo @anansrivastava 

I am also having the same problem and looking for a solution. Did you successfully find a solution?

Helpful resources

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!