Azure Monitor: Updating queries to match behavior differences after upgrading Grafana

fraga1 · October 23, 2020, 11:08am

Hi,

I used Azure Monitor to access Azure Log Analytics.
On Grafana 7.0.6, Grafana could create a time-series from the returned data.
Now I upgraded to 7.2.2 and I get the message: “could not convert frame to time series, returning raw table”.

How to reproduce:
Query an IoT hub with Grafana 7.0.6

    AzureDiagnostics
    | where $__timeFilter(TimeGenerated) 
    | where ResourceProvider == "MICROSOFT.DEVICES" and ResourceType == "IOTHUBS"
    | where Category == "Connections" and (OperationName == "deviceConnect" or OperationName == "deviceDisconnect")
    | extend DeviceId = tostring(parse_json(properties_s).deviceId)
    | project metric = DeviceId, state = iff(OperationName == "deviceConnect", 1, 0), TimeGenerated
    | order by metric asc, TimeGenerated

Repeat the Query for Grafana 7.2.2

Old:

New:

If I use “order by TimeGenerated asc”, Grafana can create a TimeSeries. However the order of the results is not the one I want.

Correct display of device connectivity with “discrete-plugin”:
–sorry cannot post, since I am a new member

Wrong display with “order by TimeGenerated asc”
–sorry cannot post, since I am a new member

Does someone know some keywords to enforce the old behaviour?

fraga1 · October 23, 2020, 11:09am

Additional Screenshots, missing from above

Correct display of device connectivity with “discrete-plugin”:

Wrong display with “order by TimeGenerated asc”:

gra7anag0d · October 23, 2020, 12:19pm

Hi fraga1,

I had the completely same issue. I fixed it with changing the order from asc to desc

AzureDiagnostics
   | where $__timeFilter(TimeGenerated) 
   | where ResourceProvider == "MICROSOFT.DEVICES" and ResourceType == "IOTHUBS"
   | where Category == "Connections" and (OperationName == "deviceConnect" or OperationName == "deviceDisconnect")
   | extend DeviceId = tostring(parse_json(properties_s).deviceId)
   | project metric = DeviceId, state = iff(OperationName == "deviceConnect", 1, 0), TimeGenerated
   | order by metric desc, TimeGenerated

If this fixes your problem, please mark this as solved.

fraga1 · October 23, 2020, 1:16pm

Hi there. Did you really try the query? desc fixes nothing
It’s just “could not convert frame to time series, returning raw table”.

gra7anag0d · October 23, 2020, 1:17pm

On which kusto version are you?

fraga1 · October 26, 2020, 6:59am

Sadly I do not know the exact kusto version.
On the Grafana side I am using the latest Grafana plugin of the main repository. Here the link to the one before integration: “Azure Monitor”.
On the Azure side I query against a Log Analytics Workspace pay-as-you-go.

fraga1 · October 26, 2020, 10:26am

Maybe a more straightforward question.
How do I get this selection back?
In the Query Inspector (Version 7.0.6) It is called Transformer “None” and I can select results. Which are correctly translated into time serieses. As seen by Time (20).
The 7.2.2 version is doing something differently and no automatic transformation takes place. How do I enforce the old behaviour?
Another Screenshot from 7.0.6: