how a filter(or slicer) works with direct query

[Erin001]

Hi,

Anybody can explain the how the direct query works when user selects a value from a filter? Will Power BI send the filter value as a query filter to the database and return the filtered data back to the Power BI?

if I use a parameterized SP, how can I catch the filter and the interaction among the charts and pass them as parameters to the SP?

E.g., there's a filter 'Last Name' , and 2 charts( one is for pct by gender, and another one is pct by age) on the report. 

Thanks!

[v-chuncz-msft · Accepted solution]

@Erin001 ,

You may take a look at Deep-dive into query performance with SQL Profiler and Power BI Desktop.

https://community.powerbi.com/t5/Desktop/Error-by-using-CTE-WITH/m-p/672826#M323805