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 very useful, once the source has like 4GB and any small change on queries will download again this 4GB after apply the queries change

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

3 Replies

    • 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. 😞

  • Anonymous's avatar
    Anonymous
    Not applicable
    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