Forum Discussion
Difference between Filtering with Dynamic Parameters vs. Slicers in Direct Query
I have a power bi dashboard that is connected to healthcare data via a direct query (due to size of the data source). I am using a dynamic parameter to filter by patient ID (via power query, advanced...
Thanks for responding! So would power bi perform the report level queries first? and then perform page level filters on the now smaller subset of data?
How would I capture those queries? (I'm pretty new to power bi).
Read about DAX Studio and SQL Server Profiler . Ideally you would have access to the query log of your data source too.