Hello. I am looking to link a Power Bi report to Power Automate. Specifically, I would like my Outlook to send out the Power BI report as soon as it gets published. If the report populates with names/emails, is there any way to have Power Automate send the report only to those who show up on the publish report? This seems like a cool idea but I'm having trouble figuring out if this is possible... Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Power BI and Power Automate
- Thread starter Kevin3030
- Start date
severynm
Active Member
- Joined
- Jan 8, 2021
- Messages
- 362
- Office Version
- 365
- Platform
- Windows
Welcome!
The available Power BI actions are quite limited currently, and the triggers are too, meaning that as far as I know of there's no way to do exactly what you want. Does the report get published regularly? If so, you could set your flow to run on a regular schedule based on when you know the report will be refreshed and then export the PBI report and add it as an attachment to an email.
I do not think there is any way to actually read the data of a report and include it as parameters for a flow, so you might be stuck doing that manually. I do know there is a thing in PBI called data driven alerts (Set data alerts in the Power BI service - Power BI), but I believe they have to be on a dashboard, not a report.
-------------------------------
So another thought. Where does your data come from? Depending on where it comes from and what kind of analysis is done to create the table with names, it might be possible to get what you want by creating a flow connected straight to the data source.
The available Power BI actions are quite limited currently, and the triggers are too, meaning that as far as I know of there's no way to do exactly what you want. Does the report get published regularly? If so, you could set your flow to run on a regular schedule based on when you know the report will be refreshed and then export the PBI report and add it as an attachment to an email.
I do not think there is any way to actually read the data of a report and include it as parameters for a flow, so you might be stuck doing that manually. I do know there is a thing in PBI called data driven alerts (Set data alerts in the Power BI service - Power BI), but I believe they have to be on a dashboard, not a report.
-------------------------------
So another thought. Where does your data come from? Depending on where it comes from and what kind of analysis is done to create the table with names, it might be possible to get what you want by creating a flow connected straight to the data source.
Upvote
0
Thank you for your reply! Yes, I think my solution is going to be your last thought. My data is coming from Excel so I'm going to try to set up a flow from there to send out the BI report. Should only be one extra step from what I was originally thinking. Thanks again!
Upvote
0
