Using Application Insights "Export to Power BI" queries only gives 24 hours of data

[KyleB]

My team is using an Application Insights Resource to store Telemetry data and I have used the "Export to Power BI" button to generate a Power BI query and followed the instructions to add it into my report in Power BI desktop. Unfortunately, the query only returns the last 24 hours of results. The wrapped Kusto queries use "| where timestamp > ago(14d)" and when run in the Application Insights query tool they produce the correct results. I have refreshed manually multiple times and the query evaluation yields consistent results.

[Anonymous]

I have a similar issue at the moment, did you manage to fix this?

Update: I noticed that I was reaching the 500k row limit and managed to fix it by following this article: https://whitepages.unlimitedviz.com/2020/11/exceed-the-500000-row-limit-in-application-insights-and-...

[v-yuta-msft]

@KyleB ,

I would suggest you to create a support ticket here.

Regards,

Jimmy Tao