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...
Hi Lakshmi,
It really depends. With the information provided I'm not sure that we can share that many guidelines. The underlying issue could be related to any of the following:
- Your data source is unable to fold the inner join and its subsequent expand operation
- The connector that you're using might not have the right capabilities to fold the full folding that you're trying to perform
- If you're using a gateway, perhaps try to upgrade to the latest version of the gateway
- There might be operations in your query which might be preventing the folding from happening
Below is a list of articles that might be of help in regards to understand how things can get evaluated for your query and how to try and optimize them:
- Understanding query evaluation and query folding in Power Query - Power Query | Microsoft Learn
- Query folding examples in Power Query - Power Query | Microsoft Learn
- Query folding indicators in Power Query - Power Query | Microsoft Learn
- Query plan - Power Query | Microsoft Learn
- Best practices when working with Power Query - Power Query | Microsoft Learn
If you can share some steps on how we could repro the scenario on our end, that would help us pinpoint exactly what could be happening. If perhaps you'd rather use your own dataflow, I'd recommend creating a support ticket so an engineer can take a closer look at this but, again, with the information provided it is not possible to reach a conclusion as to what might be the root cause of the issue.