Inefficient SQL Queries from Power BI (DirectQuery) for M*M relationships

Our Power BI Report has Direct Query connection to an On-Prem SQL Server. Report has a model created between 3 tables (“Account Rep Mapping“, “Orders Fact”, “Sales Rep Dim”). Please note, in our Pro...