Forum Discussion
Microsoft Fabric - Dataflow Gen2 - Merge Queries
Hello - Here are my observations when i use "Merge Queries" option in Microsoft Fabric Dataflow GEN2 with Innner join. 1. Dataflow getting failed 2. Query folding is not working with Merge Que...
jlakshminaraya if you found your merges aren't folding, the best way to deal with this is to change to the ELT pattern - create a dataflow with two STAGED entities representing the raw data to be merged, refresh it once. Then create a new dataflow and use the Dataflows connector to bring those two staged entities in - at this point they have compute from LH\SQL and you should be able to easily merge them with inner joins.