Power BI Report Server and Power Automate

[SimonSeez2]

Hello Team, 

I've got this business request where I have to share page of a Power BI Report to several users via email. My report is currently hosted on Power BI Report Server as my organisation uses an on-premise environment. Can anyone guide me or point me in the direction of an online tutorial on how I can achieve this using Power Automate? 

Best Regards, 

Simon  

[josef78]

Not possible out-out-the-box for on-premises Power BI Report Server (in case of interactive pbix reports).

Pbix reports are interactive and cannot be shared within email. In cloud Power BI Service is possible take png of pdf screenshot and send by email (via subscriptions or power automate), but this is not fully functional interactive report. And it is not possible in onprem Power BI Report Server.

Generally there are three ways for sharing reports by email:

-you can email subscribe pbix report as pdf on png screenshot (but it is very ugly) > it is possible only in cloud Power BI Service

-you can send pbix report attached in powerpoint presentation via PBI plugin, which work interactively > it is possible only for cloud Power BI Service

-you can redesign your report as static paginated report using Report Builder, and you can subscribe this paginated report by email in vary formats > it is possible in both onprem Power BI Report Server and cloud Power BI Service

[SimonSeez2]

Hello @v-henryk-mstf 

Thank you for responding. 

Unfortunately, it doesn't help much as like most Microsoft documentations, the shared link addresses concerns for only users who are on the cloud. 

Best Regards,  

[Uddin747]

Hello @SimonSeez2 , did you find a solution to connected Power Automate with Report server?

I'm in a same dilemma. 

[riskybell]

Did anyone find a way to send a BI report via email?  It seems like a simple thing, but I can't seem to find a solution.

[v-henryk-mstf]

Hi @SimonSeez2 ,

According to your description, you can refer to the following official document, which describes how to create a process through Power Automate to automatically distribute Power BI reports to the corresponding users via email.

Export and email a report with Power Automate - Power BI | Microsoft Docs

Best Regards,
Henry

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

[LeonLDZG]

This is for Cloud environment, not the Report Server, like the OP is asking