Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have two DirectQueries made that both use the same set of parameters. The only difference between the two queries is which columns are shown from the SQL query. I connected all my parameters to slicers on the dashboard and bound them correctly. The problem I'm facing is when I change the values of the slicer, only one of the DirectQueries is being updated and the results for that table on the dashboard are being changed. The other query is not changing at all and is still using the 'Current Parameters' that were set in Transform Data, not from the dashboard slicers. I copy/pasted the PowerQuery code from the working one to the other one too, so it should be working.
Has anyone faced this issue, and/or have a fix for this?
My understanding is that a parameter can only be bound to one column at a time, and vice versa.
str = if Text.Length(test_param) > 0
then " WHERE table1.col1= '" &test_param& "'"
else "",
Source = Value.NativeQuery(PostgreSQL.Database("localhost", "database"),
"SELECT table2.col2#(lf)
FROM table2#(lf)
INNER JOIN table3 ON table2.col3= table3.col3#(lf)
INNER JOIN table1 ON table1.col1= rates.col1#(lf)
"&str&" #(lf)
GROUP BY table2.col2, null, [EnableFolding=true])
in
Source
Query 2:
let
str = if Text.Length(test_param) > 0
then " WHERE table1.col1= '" &test_param& "'"
else "",
Source = Value.NativeQuery(PostgreSQL.Database("localhost", "database"),
"SELECT table1.col4#(lf)
FROM table2#(lf)
INNER JOIN table3 ON table2.col3= table3.col3#(lf)
INNER JOIN table1 ON table1.col1= rates.col1#(lf)
"&str&" #(lf)
GROUP BY table1.col4, null, [EnableFolding=true])
in
Source
Please validate your SQL queries and their joins. You seem to do crossjoins with the rates table and with table1.
User | Count |
---|---|
119 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
177 | |
84 | |
70 | |
64 | |
54 |