Problem on Azure Workbook

Question

Hi everyone

I'm having a strange issue with Azure Workbook. I have a query on Log Analytics like this:

But when inserted on a workbook, th result looks like this.

It's blanking some rows and I don't know why.

Regards

Jona

Answer 1

Hi Jona,

When using Azure Workbooks and Log Analytics, dealing with display problems where rows are blank can be disturbing. The problem could be associate to a number of different things, including incompatible data types, rendering problems, or even workbook settings.

Make sure that the exact query you use in Log Analytics is the same as the one in the Azure Workbook. Even small differences can lead to different results and check that the time range settings in both Log Analytics and your workbook are the same. Different time frames can result in different data being pulled.

Double check that your workbook is connected to the correct Log Analytics workspace. Misconfigured data sources can lead to incomplete data, examine at the settings in your workbook visualization and sometimes filters or groupings can inadvertently hide data also adjust these settings to ensure you are seeing all the data.

Consider that you have the appropriate permissions to view all the data in both Log Analytics and the workbook because lack of permissions can sometimes lead to missing data, you can also try refreshing the workbook or using a different browser to rule out any temporary rendering issues and make sure your Azure Workbooks are updated, as newer versions may fix known bugs.

Please refer below documentation links for additional information:

https://learn.microsoft.com/en-us/azure/azure-local/manage/monitor-single-23h2?view=azloc-24113#troubleshoot

https://learn.microsoft.com/en-us/azure/azure-monitor/insights/troubleshoot-workbooks

If the answer is helpful, please click Accept Answer and kindly upvote it so that other people who faces similar issue may get benefitted from it.

Let me know if you have any further Queries.