Refresh Dataflows then Dataset

[LakshtSharma99]

Hi DEVs,

I am trying to create a PowerShell script that will first refresh 3 dataflows and after it's completion only it will trigger dataset refresh. I will add that script in ETL pipeline so that once data ingested into database this script will automatically refresh dataflows and dataset.

Any reference would be appreciated. Thanks in advance.

[ppm1]

You may be able to do it with Power Automate where you can trigger a flow when a dataflow refresh completes. If one of your three always takes longer, you could trigger off that one. There are also refresh dataflow actions, so you could build something more advanced too.

Pat

[LakshtSharma99 · Accepted solution]

Thanks for your suggestion. I have completed my PowerShell script by using REST APIs and it's working fine as expected.