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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
kehamparam1
New Member

PowerBI Report Export in csv format via Rest API

Hi,

PowerBI provided CSV format export API for Paginated Reports alone, not for normal reports which support only pbix, ppt, png formats.

Reference: https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exporttofile

Is there any API to export PowerBI reports in CSV format?

If not, is there any API to get the exact data present in a particular report?

Can you please help me with a solution/clarity on this since am looking for it for a long time.

4 REPLIES 4
Anonymous
Not applicable

Hi @kehamparam1,

It seems like you are searching for programming functions to export power bi content as same as power bi export features.

Export the data that was used to create a visualization 

As Greg_Deckler said, current power bi seems not to release these features to Power bi REST API.

If you still want to achieve these, I think you need to trace and analytic the power bi export features to find out the 'request url', header, correspond request tokens, and parameters.  Then you can simulation these operations based on scripts or programming languages. (notice: these operations obviously complex than developing on rest api and they required you are familiar with using programming language/script on web development)

In my opinion, I'd like to suggest you submit ideas to add more export APIs.

Regards,

Xiaoxin Sheng

Greg_Deckler
Community Champion
Community Champion

@kehamparam1 - That is only supported for paginated reports, I do not know of any way to get a CSV of a report. 



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

Thank you @Greg_Deckler 

In that case, is there any api to retrieve direct data from a powerbi report or from a powerbi dataset ?

Not the metadata, the actual data which we have mapped to be shown in the report.

@kehamparam1 - I was looking at the REST API and I couldn't find anything 😞



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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.