I have made a nice application insights analytics query, which I use for my Power BI report. But the data goes only 9 days back in time. After 9 days the data is removed. Is there a way to store those results to build up more historical data?
I started with some stream analytics, but then I have to make another query in another language. I think that is a waste of time.
Is there a way to use my analytics query and have historical data?
Maybe the rest SDK can help you? https://dev.applicationinsights.io/. You can create queries and store the result wherever you want. Like Azure Blob Storage or Azure Table Storage and use that as input for Power BI.