Forum Discussion

rumittal's avatar
rumittal
Microsoft Employee
7 years ago

parameterised queries from Kusto

IS there a way to create parameterised queries from Kusto and render them into PowerBI ?

For example, I have a Kusto query that can run for multiple teams, I want to provide TEam option alongwith PowerBI dashboard so the Query can be executed at run time to get data for that team ?

parameter
Publish to Web Feature

3 Replies

  • Rothbardian's avatar
    Rothbardian
    Microsoft Employee
    6 years ago

    This Best practices for using Power BI page provides a method of providing parameters in PowerBI for ad hoc Kusto queries. 

     

    I am doing the same thing right now, building a line chart visual of page views over an arbitrary time with arbitrary bins. #LivingTheDream

  • TrevanBangsund's avatar
    TrevanBangsund
    Microsoft Employee
    6 years ago

    Try Lens Explorer for KQL visuals. You could also store the queries in a Azure Devops Code Depo and then link that to the PowerBI.