Forum Discussion

Shreenav's avatar
Shreenav
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Syntax for Dynamic M query

I want to write a Dynamic query in power editor to import dynamic data with a parameter let us say subsId. In KQL, I want that to filter my data with a where clause of subscriptions id in a list. Wha...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Shreenav,

What type of data source are you worked? If you mean the SQL or Oracle data source which support query string, you can try to parametrize them with query parameters to achieve dynamic M query. (these query string will get different results when you changes on the query parameters)

Regards,

Xiaoxin Sheng