This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
HI Guys,
I´m doing lot of changes in my queries and some of changes need to be check on view mode, so i want to know if there is anyway to change the queries without refresh data, it would be very useful, once the source has like 4GB and any small change on queries will download again this 4GB after apply the queries change
Solved! Go to Solution.
Hi @Anonymous,
Maybe you can try yo parameterize your query string with query parameters, then you can dynamically change it without refresh.
let
Source = Sql.Database("xxxxx", "xxxxx", [Query=paramter1])
in
Source
Notice: new query data structure should similar to cached data structures or it will cause the 'key not match' issue.
Regards,
Xiaoxin Sheng
Hi @Anonymous,
Maybe you can try yo parameterize your query string with query parameters, then you can dynamically change it without refresh.
let
Source = Sql.Database("xxxxx", "xxxxx", [Query=paramter1])
in
Source
Notice: new query data structure should similar to cached data structures or it will cause the 'key not match' issue.
Regards,
Xiaoxin Sheng
You can turn off background refresh in options
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
HI Steve,
Thank you for your answer!
I have already disable the option, but the refresh keep happening after query change. 😞
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 36 | |
| 33 | |
| 31 | |
| 21 | |
| 16 |
| User | Count |
|---|---|
| 66 | |
| 55 | |
| 31 | |
| 24 | |
| 23 |