Syntax for Dynamic M query

[Shreenav]

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. What type of parameter should I create? What should be syntax of the query in power editor? 

Let us say I create a parameter "SelectedSubsIds", what should be the type, and how should I write the syntax "where subsId in ....."

[Shreenav]

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.

[Anonymous]

Hi @Shreenav,

You can take a look at the following link to use Value.Native Query() to achieve inline KQL query.

Chris Webb's BI Blog: Inlining KQL Query Fragments Using Value.NativeQuery() In Power Query (crossjo...

Notice: the query part are text values, you can also parameterize and spliced with power query parameters.

Regards,

Xiaoxin Sheng

[Shreenav]

Followed this article but getting this error: 

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

[Anonymous]

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

[Anonymous]

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