This is going to sound strange, but one of the things I like about tuning Power BI DirectQuery semantic models is that their generally-slower performance and the fact you can see the SQL queries that ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results