Visualization

Now that the data is stored in Eventhouse you can utilize multiple options to visualize the data.

Power BI

You can Visualize data in a Power BI report.

RTI Dashboard

Real-Time Dashboards allow you to visualize data from a KQL Database.

Grafana

There is an existing data source in Grafana that allows you to connect to and visualize data in a KQL database.

KQL Queryset

KQL Querysets can be used to explore and visualize you data. Along with pin visuals to a Power BI Report or RTI Dashboard.

SDKs

There is a fully supported REST APIs along with SDKs for .NET, Python, R, Java, Node, Go, and PowerShell that allow you to query data.

Useful Blogs

• KQL DB Query Performance
• Filtering and visualizing Kusto data in local time
• Connecting from Power BI to ADX on a private end point
• How to use M dynamic parameters without most limitations
• Timespan/duration values in KQL, Power Query and Power BI
• To BE or not to be – case sensitive using Power BI and ADX/RTA in Fabric
• Why are 273 queries needed to refresh one chart in Power BI ?
• Using KQL query settings in Power BI
• Using Query results cache in Azure Data Explorer (aka Kusto) from Power BI
• How many to many relationships affect the number of queries required to refresh matrices and tables
• KQL joins in Power BI and not only
• Using .show queries to understand and optimize the KQL sent from PBI to Kusto
• Near real time reports in PBI + Kusto
• How to force filtering on at least one criterion when querying ADX data in direct query mode
• Search text in a Kusto/ADX table using any number of terms from Power BI
• Power BI modeling with ADX - cheat sheet
• Using Dual Mode dimension in Power BI with ADX data

Next: Demo/PoC Accelerators