topic Re: parameterised queries from Kusto in Report Server

parameterised queries from Kusto

rumittal — Tue, 19 Mar 2019 18:06:08 GMT

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 ?

Re: parameterised queries from Kusto

Artak — Thu, 07 Nov 2019 00:48:17 GMT

I wonder if you got a solution for this?

Re: parameterised queries from Kusto

Rothbardian — Thu, 05 Mar 2020 01:19:41 GMT

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

Re: parameterised queries from Kusto

TrevanBangsund — Thu, 25 Jun 2020 23:13:27 GMT

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.