BigQuery as source join error: "cannot be used without a condition that is an equality of fields"

[janinw]

Hi all,

I am creating a new table in Power BI based on direct query joins from BigQuery tables.

In the power query M language everything is correct syntax-wise and also the table looks fine when running the script.

However, when I want to display a visual of a column of that newly created table, I receive the following (Big Query/SQL) error:

"Full outer join (or "left outer join") cannot be used without a condition that is an equality of fields from both sides of the join."

When I use inner join instead, there is no issue displaying a count of the metric.

This is the code I am using:

JoinTables1 = Table.Join(Tickets, "nID", Customer, "CustomerNumber", JoinKind.Inner),
JoinTables2 = Table.Join(JoinTables1, "CustomerKey", Screening, "ScreeningCustomerKey", JoinKind.LeftOuter)

As a visual want to display the count of another metric, the screening sequence number, coming from the Screening table - however, then I get the error message described above.

Many thanks,

Janine

[Bamak]

Hi  janinw

We have the same problem on our campany

Don't hezitate to contacte microsoft  .... they don't want to move on that ;>) 

https://community.powerbi.com/t5/Desktop/Query-M-Merge-2-Big-Query-tables-Lef-join-issue/td-p/143548...

[v-juanli-msft]

Hi @janinw 

As tested, it works on my side.

Could you share some example data for test?

In addition, To dispaly visual, instead of merging queries, you could create relationships among tables and create measures.

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

https://docs.microsoft.com/en-us/power-bi/desktop-measures

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.