Is there a limit of merges?

[Tahech]

Hi guys!

I'm modelling a tab of my BigQuery database. And while doing LeftOuter Joins, it reached a point where I can no longer make any other LeftOuter Join, because Power BI doesn't recognize the relation. 

Independent of the column chosen, when I join them, Power Query act like there is ANY relation between them, but... if I delete any other join Power Query magically starts working again, but if I try any aditional join, the problem/limitation occurs.

[v-stephen-msft · Accepted solution]

Hi @Tahech ,

Maybe if you trim or clean those text columns? Are there steps in your query after trying to merge?

The following article lists some possible reasons:

Why is My Merge Not Working in PowerQuery? - The Finance Department Training Company

Best Regards,

Stephen Tao

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

[PC2790]

Hey @Tahech ,

There should not be a limit on the number of merge operations apart from deteriotating perfomance of your model.

Could it be that after multiple merges, no recognisable common columns are left.

Did you try fuzzy matching?