Linked Dataflows are Not Refreshing

Good morning Anonymous ,

Is the architecture you have look like this

X is siphoning data from SQL server, and B referred to X and another dataflow A. Now that when C collect data from B, the congestion happened at B that data is showing at B, but not C.

The change I made is Y solely referred to X, then B is now referring to Y and A.

Somehow somewhere I read about the Enhanced compute engine, both issues had their dataflows remains in the default mode with is Optimized. This mode is turned off when there is dataflow connected to datasource, but turned on for those has linked entities of another dataflow. Maybe the issue is right there that if B referred to X (the staging dataflow that is immediate connected to SQL Server) and linked entities from dataflow A; this mixed mode throw B into confliction of Optimized Enhanced Compute Engine.

My got fixed this morning after I made that change, if you see it is applicable, try it out after technical meeting (if not yet solution), then let me know.