Application Insights is great for collecting metrics and even traces (even from Serilog).
But now, how can we mine all this data and expose all of this data ?
We can use Dashboard by adding dedicated Application Insights widgets.
Authentication will use API Key.
But it will only display metrics.
It seems impossible to use Kusto query.
Power BI Desktop without any connector let you use Kusto query !
You will need to publish it to share the data.
Azure Data Explorer can display Kusto query, if you have an Azure Data Explorer Cluster.
Hope this helps !