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  [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…