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

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