cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Integrate PowerBI and Flow for Timesheet report with Email Notification

Hi Team,

 

I am currently trying to create a power BI report that is integrated with Microsoft Flow to send out email to multiple employees. Below you can find more information about Data Source and Current Challenges.

 

Data source: Project Data Service(Odata feed).

I have Table with Columns - EmployeeName, Status, Week, Email.

 

The report has 1 table with all the above colmns and 2 slicer, 1 for week and other for status. I need to filter Employeename for current week that has status- Inprogress.

 

Endgoal- To send out email to all the employees that are filtered in this report.

 

Challenges:

1. how can I pass the email list from power BI to Flow?

2. I tried using PowerApps , but there is no data connector similar to Odata feed to connect to entities from project Data Service

3. I can create a  data alert on the count of Employees  in a label and trigger the flow, however I am not sure on how can I pass the email list from the Power BI to Flow.

 

Any help on this is appreciated.

 

Thanks

 

 

 

1 REPLY 1
Anonymous
Not applicable

Same here. There must be a way of triggering a Microsoft Flow from a Power BI report. The report should be parametrized by any available filters on the report and result in a list sent as input data to Flow. Flow can do the rest - like email lists, etc... But there is no Flow integration starting from a filtered Power BI report.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.