Refresh Semantic model and Automate emails based on alert

[wkasaval]

> 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 license just for this still dont have the options..
>>> It was recommended here to use Powerautomate, there is no such options in powerautomte...

> I want to send an email when the dataset refreshes (successfully) but this seems only possible with:
>>> Setting thresholds, which does not work for me, as the numbers im reporting change and accumulate, so thst wont work
>>> Using power automate, they seem to have removed all the possible suggestions given here.
>>> Finally chat gpt etc is recommending using Azure with Rest APIs etc...

Such simple things, they have made hard/impossible....
How is this done simply -> refresh a dataset at a given time eg: 4:05 and send an email when its complete....
Please help...

[Anonymous · Accepted solution]

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]

It 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.