Sending Power BI reports to dynamic emails

[Anonymous]

Hi guys, 

i have a table with data on products that are not sellable coming in on a DAILY basis. Now i want to send emails from Power BI Service each day to the respective managers of those products as alerts. The table looks basically like this:

I want Power BI to only send the relevant items for each manager to them in case new data for the current date came in. So also the emails to which the report should be sent should be taken from the table. They should not be hardcoded but dynamically taken from the table.

Does anybody know how to do that in Power BI Service?

Thanks already!

[lbendlin · Accepted solution]

Use Power Automate to run DAX queries against your dataset.

https://powerbi.microsoft.com/en-us/blog/unlocking-new-self-service-bi-scenarios-with-executequeries...