FULL OUTER JOIN taking too long to execute.

[saylee]

I have 2 huge tables. I am trying to merge those using full outer join but it is taking way too long. Is there a problem with my data model of these 2 datasets? what should be the ideal data model or what can I do differently to join these 2 tables?

[v-yinliw-msft]

Hi @saylee ,

I am not sure what kind of methods did you try to merge the huge tables, if you use the Power Query, because the size of dataset will increase times the number of columns. So I suggest that unless necessary, you can load these tables in the Power BI Desktop and make relationships.

You can refer this documentation to optimize:

Optimization guide for Power BI - Power BI | Microsoft Learn

And you also can check this threads to look for other methods:

Solved: Slow Power Query & refresh performance w/ multiple... - Microsoft Power BI Community

Solved: Power Query Editor REALLY SLOW - SQL SERVER CONNEC... - Microsoft Power BI Community

Solved: Transformations in Power Query - Very Slow Perform... - Microsoft Power BI Community

Hope this helps you.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.