Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi janinw
We have the same problem on our campany
Don't hezitate to contacte microsoft .... they don't want to move on that ;>)
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |