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!
Solved! Go to 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
@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
User | Count |
---|---|
137 | |
61 | |
60 | |
55 | |
47 |
User | Count |
---|---|
130 | |
78 | |
55 | |
54 | |
52 |