Forum Discussion
Best Practice for dealing with WEB API Source refresh on DataFlows
Hey All, I was wondering what your work around is for refreshing WEB API for Dataflow. Basically I have multiple queries using difference calls, but all under the same API. So when they refresh ...
You may want to split your queries into different dataflows and chain their sequential execution via Power Automate so that one starts just after the other is finished. For illustration, the left branch of the process below is sequential, the right one runs in parallel:
Woah, creative! I'll risk making my workspace really messy 😛 But it's a pretty full proof idea if all else fails.
Yes, you do want to name your dataflows with meaningful and consistent names if you're going to have many of them. I like to prepend numbers in case I have many dataflows and they're meant to be chained in a sequence (e.g. staging vs. silver vs. gold stages).
