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
Anonymous
Not applicable

power bi rest api - export to file

I am new to api so please bear with me

 

Background: I am using a power bi report builder, and built an rdl, (source is a powre bi pbix file).

Then in power bi service, I use Get File, my saved .rdl file...

Goal: Have the output of this file to be emailed as an excel to user

What I tried: You know we can hit "try it" on power bi api reference , so I tried export to file api, entered the report id, and hit run, i got json as a response

 

Question: What to do next ? How to invoke / integrate this from power bi ? I believe i have to run a polling api call to get the power bi url ? I am confused about what to do next. The below link, is very vague

 

https://powerbi.microsoft.com/en-us/blog/export-report-to-pdf-pptx-and-png-files-using-power-bi-rest...

 
2 REPLIES 2
v-xuding-msft
Community Support
Community Support

Hi @Anonymous ,

 

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-xuding-msft
Community Support
Community Support

Hi @Anonymous ,

Do you register an app? If not, please reference the document to do it firstly.

Register an Azure AD application to use with Power BI 

 

And here is a blog about calling the Power BI Export API from Power Automate. Perhaps it do not fully meet your requirement. However, the details that the author mentioned might help you.

Calling The Power BI REST API From Microsoft Flow, Part 1: Creating A Flow Custom Connector 

Calling The Power BI Export API From Power Automate, Part 2: Creating A Flow That Exports A Paginated Report To A CSV File 

 

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.