Forum Discussion

SimonSeez2's avatar
SimonSeez2
Frequent Visitor
4 years ago

Power BI Report Server and Power Automate

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  

Power Automate
Report Server

6 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    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's avatar
      LeonLDZG
      Frequent Visitor
      3 years ago

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

  • SimonSeez2's avatar
    SimonSeez2
    Frequent Visitor
    4 years ago

    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's avatar
      Uddin747
      New Member
      3 years ago

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

       

      I'm in a same dilemma. 

      • riskybell's avatar
        riskybell
        New Member
        2 years ago

        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.

  • josef78's avatar
    josef78
    Memorable Member
    3 years ago

    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