Forum Discussion
Send Auto Email on Data refresh to Outlook Using Power Automate
the requirement is whenever the data is refreshed with schedule refresh
those things are mutually exclusive. If you have the luxury of knowing when your source data is refreshed then you want to issue an ad-hoc refresh request, not a schedule.
An auto email should be sent to outlook with updated visuals using Power Automate.
You can use report subscriptions for that but these cannot be triggered ad hoc, they can only be scheduled.
Power Automate has no access to your Power BI visuals. The best you can do is run the same DAX query and then create HTML tables to include in your email.
i need to get attachment of refreshed report in email after schedule refresh is completed.There is nothing built in Power Automate for that. You need to create your own custom action connector, and use the Enhanced Refresh API to get and monitor a request ID for its completion status (or otherwise use polling to check the status of the TOP 1 request in the refresh history).
By Doing the above steps i am unable to get the full report visuals and getting error as well.
Requirement is: i will schedule a refresh in power bi sevice for excel dataset used.
Once refresh is comepleted on scheduled time, within 5-10 mins i should get an email in Outlook with updated visuals used in power bi .
Please let me know with the steps and actions taht will be helpfull
lbendlin Anonymous
By Doing the above steps i am unable to get the full report visuals and getting error as well.
Requirement is: i will schedule a refresh in power bi sevice for excel dataset used.
Once refresh is comepleted on scheduled time, within 5-10 mins i should get an email in Outlook with updated visuals used in power bi .
Please let me know with the steps and actions taht will be helpfull
After the refresh is confirmed complete and successful, add an action to export to PPT or PDF, then append that to your email. Size limitations apply.