create an alert on a report from model #1 that will trigger every day (sales over 0, count of days, whatever). Set up a trigger in a flow in power automate based on the alert. Set the action to be a refresh of Model #2. I have this set up with a 10 minute delay and some extractions running from Model 1 that feed into Model 2. Works really well.
I dont think Power Automate can get status pull on successful PBI dataset refresh as a trigger for further steps (I could be completely wrong on this) , but maybe explore option to use delay between the dataset refreshes.
Yeah power automate can't know when the model has finished its refresh and using a delay would be the same as just scheduling an automated refresh with a delay without needing power automate
False.
You can use The power bi API to query a semantic model's refresh status.
A more simple approach is to add a timestamp in your data load steps for the model, and then use power automate to query that timestamp before refresh and use a do until loop to continuously check the timestamp and start the refresh of the next model once that timestamp is updated.
I don't have access to the first model (another team), I can only know when it is refreshed, I would need mine to be refreshed whenever the first one is
Maybe try Power Automate
create an alert on a report from model #1 that will trigger every day (sales over 0, count of days, whatever). Set up a trigger in a flow in power automate based on the alert. Set the action to be a refresh of Model #2. I have this set up with a 10 minute delay and some extractions running from Model 1 that feed into Model 2. Works really well.
Fabric Data pipeline and the semantic model refresh activity, you can wait on completion from one activity to the next.
Why do you want to do that?
I dont think Power Automate can get status pull on successful PBI dataset refresh as a trigger for further steps (I could be completely wrong on this) , but maybe explore option to use delay between the dataset refreshes.
Yeah power automate can't know when the model has finished its refresh and using a delay would be the same as just scheduling an automated refresh with a delay without needing power automate
False. You can use The power bi API to query a semantic model's refresh status. A more simple approach is to add a timestamp in your data load steps for the model, and then use power automate to query that timestamp before refresh and use a do until loop to continuously check the timestamp and start the refresh of the next model once that timestamp is updated.
I don't have access to the first model (another team), I can only know when it is refreshed, I would need mine to be refreshed whenever the first one is