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
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
120 | |
74 | |
65 | |
53 | |
52 |
User | Count |
---|---|
200 | |
104 | |
85 | |
80 | |
77 |