Is there anyway for me to test this?
I want to see if a direct query PBI report runs its query by passing the drillthrough parameters into the WHERE clause.
I have a report that shows number of sales by day, then you can click on the day and right click to drill through to POS terminal sales details.
When it opens that child report, is it loading or querying ALL The records or does it pass that drillthrough field into the TSQL query as a WHERE clause?
Parent Report: Right click on field "SalesDate" the cell '2019-09-01' and select Drill Through to "POS Terminal Sales Details".
"POS Terminal Sales Details" is just a TSQL direct query that does:
SELECT SalesDate, POSTermID, TransactionID, UserID, LinePrice, other random fields....
FROM PosSalesTable
When that query runs, will the report return everything and then filter inside PowerBI, OR, will the detail report do:
SELECT SalesDate, POSTermID, TransactionID, UserID, LinePrice, other random fields....
FROM PosSalesTable
WHERE PosSaltesTable.SalesDate = '2019-09-01'
Can we somehow run a query profiler on this from inside PowerBI or PBI Desktop? I don't know how to pass a drillthrough filter across PBI desktop to see it in the performance analyzer?
