Automatically send mail with a table.

[pbi1908]

Hi everyone, 

I have a report with a table of duplicated values and i want to send this list to some users by mail. 

First that i did i created an alert in PBI Dashboard and then i added a button to send the mail through power automate. 

But i want either the user when he received the mail to go directly to the report (not the dashboard) since from there he can't press the button to send the mail, or the mail to send automatically every morning a standard time so the button to be clicked automatically every morning at 09:00 let's say. 

Is that possible ?

Thank you.

[VahidDM · Accepted solution]

HI   @pbi1908 

Yes, you can change the Trigger of your flow on Power Automate from Power BI Button to the Recurrence and then set the time (Early morning) to automatically send the report to their emails.

https://learn.microsoft.com/en-us/power-automate/run-scheduled-tasks?WT.mc_id=DP-MVP-5004936

check my blog post related to this topic:
https://www.vahiddm.com/post/how-to-have-an-automated-power-bi-version-control-with-power-automate

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!