Dynamic K query in power bi

[raj777karthik]

i have a dataflow table which has Kql in which one of column Source id has been hardcoded(Ex.2000 value has been hardcoded)*in query editor.i have another dataflow table which Source id has been populated from Excel manually.So my requirement is to bring Source id from dataflow table to Kql query dynamically as parameter .Instead of hardcode value i should bring source id from table as parameter.

Note:This is dataflow we are working and not dataset.

K query

let
Source = Kusto.Contents("https://kusto.net", "Shared", "let map = datatable(ServiceOid: string) [ ""01c29849-61c3-4646-80c1-24c7dd98f2e7""--hardcoded value, ]; map | join kind = leftouter ( Orderline| summarize Description = strcat_array(make_list(Description),',') by Sourceid) on Sourceid | 
in
Source

[artemus]

Instead of creating a datatable, just do a join on your kusto query with your dataflow table (after reducing it down to a small size). If the data table is small enough, it will be converted to a datatable in kusto when sending the query off.