Forum Discussion
DirectQuery Not Updating with Parameter Change
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?
3 Replies
My understanding is that a parameter can only be bound to one column at a time, and vice versa.
- SpoilerYes, I have that each parameter is only bound to one column. I am using the same column/parameter value in mulitple queries. Here is sample of my M queries, the only difference in the queries is the bolded parts:
Query 1:
letstr = 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:
letstr = 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
When I change the value of test_param, only the table connected to Query 1 updates, the table for Query 2 does not.Please validate your SQL queries and their joins. You seem to do crossjoins with the rates table and with table1.
