Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Change queries without refresh data

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 ve...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
SteveCampbell
Icon for Memorable Member rankMemorable Member
6 years ago

You can turn off background refresh in options

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Steve,


    Thank you for your answer!

     

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