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...
Excellent question. In my opinion dynamic query parameters are the equivalent of report level filters. Unbound slicers are page level filters.
You would have to capture the queries that are executed against the Direct Query source to see if there is any material difference.
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.