Forum Discussion
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...
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)
what is the cardinallity of the join columns in table1? Anything above 50K is asking for trouble.
>1 million.
Do you think there is a workaround?You will need to look into further normalization.
Composite model guidance in Power BI Desktop - Power BI | Microsoft Learn
I recommend you read this article thoroughly. It talks about composite models but the principles apply in-model as well.
Use composite models in Power BI Desktop - Power BI | Microsoft Learn