Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 ?
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.
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
I wonder if you got a solution for this?