topic Re: Refresh Dataflows then Dataset in Developer

Refresh Dataflows then Dataset

Anonymous — Thu, 06 Jul 2023 15:33:47 GMT

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.

Re: Refresh Dataflows then Dataset

ppm1 — Sat, 08 Jul 2023 12:40:58 GMT

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

Re: Refresh Dataflows then Dataset

Anonymous — Sat, 08 Jul 2023 13:03:41 GMT

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