topic Re: Power BI Report Server and Power Automate in Report Server

Power BI Report Server and Power Automate

SimonSeez2 — Sun, 20 Mar 2022 06:46:12 GMT

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

Re: Power BI Report Server and Power Automate

v-henryk-mstf — Wed, 23 Mar 2022 02:18:06 GMT

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.

Re: Power BI Report Server and Power Automate

SimonSeez2 — Fri, 25 Mar 2022 06:37:30 GMT

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,

Re: Power BI Report Server and Power Automate

Uddin747 — Thu, 03 Nov 2022 18:01:12 GMT

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

I'm in a same dilemma.

Re: Power BI Report Server and Power Automate

josef78 — Fri, 04 Nov 2022 09:22:13 GMT

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

Re: Power BI Report Server and Power Automate

LeonLDZG — Thu, 10 Nov 2022 07:49:49 GMT

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

Re: Power BI Report Server and Power Automate

riskybell — Tue, 28 Nov 2023 11:32:52 GMT

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.