Forum Discussion

Shreenav's avatar
Shreenav
Microsoft Employee
2 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
Shreenav's avatar
Shreenav
Microsoft Employee
2 years ago

Working with Kusto(KQL). Need syntax help there only, if you can provide any demo M query that selects a data from a Kusto table with a where clause of ids in "parameter".

Now this parameter should be such that it binds to a column of ids and I be able to add a slicer for these ids with multi-select and select all enabled.

  • Shreenav's avatar
    Shreenav
    Microsoft Employee
    2 years ago

    Followed this article but getting this error: 

    Expression.Error: Native queries aren't supported by this value.
    Details:
    [Table]