Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Refresh Dataflows then Dataset

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.

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

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

2 Replies

  • ppm1's avatar
    ppm1
    Icon for Solution Sage rankSolution Sage
    3 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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