Forum Discussion
wkasaval
1 year agoFrequent Visitor
Refresh Semantic model and Automate emails based on alert
> Automating of the Refreshing of sematic model is only for eg: 1:00pm or 1:30pm. I have seen answers saying premium allows for more finer time selctions but I also see people who bought the prem li...
- Anonymous1 year ago
Hi wkasaval ,
Just like lbendlin methioned, you can use power automate to do this.
Create a schedule flow and set the start time of the trigger, and use the Delay action to delay sending the email. If the refresh fails, no email will be sent, but you will receive an email that the flow failed. If you want to receive mail even when the refresh fails, you can add a parallel action and set it to run when the semantic model refresh fails.
Setting of Send an email(2).
Best regards,
Mengmeng Li
lbendlin
Super User
1 year agoIt was recommended here to use Powerautomate, there is no such options in powerautomte...
Yes, there is. But it's still using the legacy "dataset" name for semantic models.
Using power automate, they seem to have removed all the possible suggestions given here.
You will have to create your own polling flow for that. for example:
Not simple at all, but certainly possible, and it works reliably once set up.