Forum Discussion

hi_world's avatar
hi_world
Icon for Helper III rankHelper III
2 years ago

million-dollar question - Non-Optimal SQL Queries for Many-to-Many Relationships

Hello,  Power BI Direct Query on GCP Views Generates Non-Optimal SQL Queries for Many-to-Many Relationships The problem is that it makes a kind of cross join on NULLs. The following article de...
Need Help
Tips and Tricks
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

What's the cardinality of your join columns?

hi_world's avatar
hi_world
Icon for Helper III rankHelper III
2 years ago

table1 one to many table2 

table1 one to many table3 
This happen when i take fields from table2  and table3 (at the end it's a many to many)