Integrate PowerBI and Flow for Timesheet report with Email Notification

[Anonymous]

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

[Anonymous]

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.