Forum Discussion

roozbeh_al's avatar
roozbeh_al
Frequent Visitor
5 years ago
Solved

send an email with power bi report server

I want to send an email to my customers from the data on my dashboard - when data reaches its dangerous level, or on a daily basis. I create my dashboards using Power BI Desktop and then publish them on the Report Server, and I do NOT have a pro license.
Is there any means (like microsoft flow) to do this for us?

  • josef78's avatar
    josef78
    5 years ago

    It depens, if you need only send an information about data, there is more options.

    If you need send "report" is best (I think) option Paginated report using Report Builder. 

     

    After you have Paginated published on Power BI Report Server, you can subscribe. You can subscribe (one or more) as standard subsribe (fixed time period and recipients) or as datadriven subsriptions (content of subscription and recepients can be drived based on data)

4 Replies

  • josef78's avatar
    josef78
    Icon for Memorable Member rankMemorable Member

    You can use Report Server Subscription or Data driven subcsription.

    First, if you want sent a report in email, you must create static (paginated) report, in Report Builder. If you are using dedicated PBI model in SSAS, you can reuse model and DAX expressions. Or you can create from data source directly.

    • roozbeh_al's avatar
      roozbeh_al
      Frequent Visitor

      So you mean creating the paginated report is the best solution?
      After I made paginated, how can I send the email?

      • josef78's avatar
        josef78
        Icon for Memorable Member rankMemorable Member

        It depens, if you need only send an information about data, there is more options.

        If you need send "report" is best (I think) option Paginated report using Report Builder. 

         

        After you have Paginated published on Power BI Report Server, you can subscribe. You can subscribe (one or more) as standard subsribe (fixed time period and recipients) or as datadriven subsriptions (content of subscription and recepients can be drived based on data)