Forum Discussion
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 popu...
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.