Errors when Merging Query's as New


I am trying to merge with queries together as a new one. My data is being pulled down from BigQuery. When I try to merge I get the following errors. I have tried it with a few different join types with no luck. The most recent was a Full Outer join.

I have tried clearing my cache on PowerBi and that hasn’t worked. I have a unique key in both tables that correspond to each other. Any thoughts? I have done some looking but haven’t found anything helpul.

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [42000] [Microsoft][BigQuery] (70) Invalid query: FULL OUTER JOIN cannot be used without a condition that is an equality of fields from both sides of the join…


After some digging around, I found the following thread on Reddit of all places, where someone experiencing the same error walks through how they solved it:

There’s useful info throughout the thread, but here’s what I think is the key:

I hope this is helpful.

  • Brian

Thanks for posting your question @matthew.wright. To receive a resolution in a timely manner please make sure that you provide all the necessary details on this thread.

Here is a potential list of additional information to include in this thread; demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

Including all of the above will likely enable a quick solution to your question.

Hi @matthew.wright, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!