Missing Data from Log Analytics Workspace AppAvailabilityResults Table in Power BI Desktop

[Anonymous]

We are encountering an issue with incomplete data retrieval from the Log Analytics Workspace (LAW) AppAvailabilityResults table when exporting into Power BI Desktop. A portion of the records are missing, and this occurs at random, with no discernible pattern. The total number of records returned in Power BI does not match the actual count for specific time ranges, such as the past 24 hours, 1 hour, or a specific day.

Moreover, Power BI seems to cap the data load at approximately 0.49 million records, even though the expected volume is significantly higher.

For example, the AppAvailabilityResults table generates approximately 0.25 million new rows daily. When pulling data for a 7-day period, we expect around 1.7 to 1.8 million rows. However, the data consistently stops at or below 0.5 million in Power BI reports.

[Anonymous]

Hi @Anonymous ,

Thank you for your quick response. I appreciate the time and effort you’ve put into helping me with the issue I’ve been facing.

I have another issue that I’d like your assistance with.

As you may know, there are two ways to export a KQL query from Log Analytics:

1. Export to Power BI (as an M query)
2. Export to Power BI (new Dataset) – This method creates a semantic layer dataset in Power BI Service, which can be consumed in Power BI Desktop using Direct Query.

However, I'm facing a problem with the second method. Even though the dataset is created and consumed in a Power BI report via Direct Query, the data is not refreshing live when users interact with it. The data remains static, and I have to manually refresh the dataset in Power BI Service to see updates.

Could you help clarify what might be causing this issue?

[Anonymous · Accepted solution]

Hi  @Anonymous, 

Quote from microsoft:

The export operation is subject to the Log Analytics Query API limits.

If your query results exceed the maximum size of data returned by the Query API, the operation exports partial results.

Additionally, if you want to go over the limit , please check the following article:

Exceed the 500,000 row limit in Application Insights and Log Analytics with Power BI – The White Pages

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.