Forum Discussion
Shreenav
Microsoft Employee
Microsoft EmployeeSyntax 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...
Hi Shreenav,
You can take a look at the following link to use Value.Native Query() to achieve inline KQL query.
Notice: the query part are text values, you can also parameterize and spliced with power query parameters.
Regards,
Xiaoxin Sheng
ShreenavMicrosoft Employee
Microsoft EmployeeFollowed this article but getting this error:
Expression.Error: Native queries aren't supported by this value.
Details:
[Table]
HI Shreenav,
Can you please share some more detail about these M queries that return the error messages?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng