I am using Power BI in direct query mode to create a simple table visualization that aggregates data. However, I have noticed that Power BI generates and sends two separate SQL queries to the database for this simple report. Moreover, instead of using a straightforward SELECT statement with a GROUP BY, the SQL queries contain multiple levels of subqueries, making them inefficient.

I need to check the sources of the tables in a PowerBI report. The semantic model is connected to both SharePoint and a database, so it’s unclear which data is coming from where. When I click on “Transform Data,” it prompts me to add a local model. Despite adding it, no queries are displayed.
Where the problem might be?