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

For me no, the initial problem is that the powerbi engine generates an unoptimized sql query on the views.
if I replace the views with tables and I define not null constraints on my join key columns in the powerbi model, the queries are generated correctly and the performance is good.
I have to keep views and not tables, that's why I'm trying to understand why powerbi behaves in an abnormal way with views and how to get around it?
the article that I shared explains very well this very strange behavior of powerbi en direct query on big data views.