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:

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 SQL statement. Additionally, though not included in the trace image, the WHERE clause reflects a slicer (filter) selection for a specific calendar year in a Power BI report.