Forum Discussion

raj777karthik's avatar
raj777karthik
Microsoft Employee
4 years ago

Dynamic K query in power bi

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

Need Help

1 Reply

  • artemus's avatar
    artemus
    Microsoft Employee
    4 years ago

    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.