Change queries without refresh data

[Anonymous]

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

[Anonymous · Accepted 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

[SteveCampbell]

You can turn off background refresh in options

[Anonymous]

HI Steve,

Thank you for your answer!

I have already disable the option, but the refresh keep happening after query change. 😞