Forum Discussion
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?
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
Memorable 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_alFrequent Visitor
So you mean creating the paginated report is the best solution?
After I made paginated, how can I send the email?- josef78
Memorable 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)