power bi rest api - export to file

[Anonymous]

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

[v-xuding-msft]

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.

[v-xuding-msft]

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