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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JeremieB
Frequent Visitor

Use Power Automate with Report Server

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:

JeremieB_0-1688406081241.png

 

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

 

5 REPLIES 5
d_gosbell
Super User
Super User

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
Super User
Super User

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.

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.


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


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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.