I have 2 gen2 dataflows in a Fabric capacity. One executes a SQL stored proc and updates a table in a Fabric warehouse. The second dataflow takes the table from the first dataflow and appends it to a table of historical data (that historical data table is in the same warehouse as the table for the current data refreshed by the first data.
My Power Automate flow refreshes these two dataflows consecutively as part of an overnight data refresh process. I noticed recently that the second flow (which results in a computed entity) doesn't seem to be including the new data in the table that's refreshed by the first dataflow. It's like the second dataflow is running before the data from the first dataflow has been written to its destination table.
So I'm wondering, do I need a way to confirm that the first dataflow refresh has completed prior to triggering the second data refresh? Right now they just run like this:
Thanks so much for any tips you can pass along!
253
Share
Report
All responses (
Answers (
