Use Power Automate with Report Server

[JeremieB]

How can I connect Power Automate to my Power BI Report Server?

My goal is to create a flow to export some Paginated Report into PDF.

Currently, I don't see my Report Server into my Workspace:

So, I guess I need to add it, but I didn't find how I could.

I thought I could use Power BI REST API and do some http request in my power automate flow, but I didn't find how I could authenticate myself to make the request: https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file

[d_gosbell]

Power Automate is a cloud service. Typically people use the on-prem report server as they do not want any of their reports accessible outside of the on-prem network. So this usually means that there is no way to connect Power Automate to Report Server. The only way would be if the Report Server was accessible from the public internet, but at that point you could just use the cloud service for your reports.

[d_gosbell]

You would typically not use Power Automate with Power BI Report Server. Report Server is usually installed on-prem and Power Automate is a cloud service so there is usually no connectivity between them.

But if you just want to export a paginated report to a PDF you can do this by creating a subscription to the report and then you can either send the PDF via email or to a network file share.

[btcorso]

Is there anyway that I can connect power automate with Power Bi Report server? 

I aim to create a button on my app (Power apps) that will trigger a flow then execute the "Refresh Now" on a report uploaded on my Power BI Report Server.

[JeremieB]

---

@d_gosbell wrote:

You would typically not use Power Automate with Power BI Report Server. Report Server is usually installed on-prem and Power Automate is a cloud service so there is usually no connectivity between them.

But if you just want to export a paginated report to a PDF you can do this by creating a subscription to the report and then you can either send the PDF via email or to a network file share.

---

I don't think I can do that. I have a Power Apps application that call my Power automate flow to generate one or more paginated report in pdf and finally, upload the pdf to an sharepoint.

[d_gosbell]

---

@JeremieB wrote:

---

---

I don't think I can do that. I have a Power Apps application that call my Power automate flow to generate one or more paginated report in pdf and finally, upload the pdf to an sharepoint.

---

Then I think you probably also need to look at publishing your paginated report to the cloud instead of hosting it on-prem. Then you should not have any issues connecting Power Automate to the report.