In the following database trace from SQL Server Profiler, a DirectQuery dataset has translated a Power BI report query into a SQL statement, which joins the SQL statements associated with the Reseller Sales, Reseller, and Date M queries:
SQL Server Profiler trace – Power BI DirectQuery report visualization
For DirectQuery datasets, it's important to understand both the individual queries associated with each table of the model as well as how the data source is utilizing these queries in resolving report queries. In this example, the three table queries are used as derived tables to form the FROM clause of the outer ...
