.set stored_query_result command returns 400 - Bad Request

[MSDkuznetsov]

What happened:

I wanted to use the https://learn.microsoft.com/en-us/azure/data-explorer/kusto/management/set-stored-query-result-command to store the state.

According to documentation, to use this command "You must have Database Viewer permissions to run these commands." - which is the case, I have confirmed that Grafana account has the appropriate permission, I have also tried to use my own principal with the same results.

What you expected to happen:

• To be able to store the state when dashboard is loaded (as a caching mechanism) or at least have some clarity about the restrictions if there are any, so that appropriate error message is shown - "not allowed to be executed, due to policy" something like that.

How to reproduce it (as minimally and precisely as possible):

1. Go to any dashboard
2. Add new panel that relies on Azure Data Explorer as data source
3. Type in the following kql statement:

.set-or-replace stored_query_result Numbers3 <| range X from 1 to 10 step 1

4. Load the query
5. Failure will be shown

Anything else we need to know?:

btw reading stored query results, works just fine:

.show stored_query_results

Environment:

• Grafana version: Azure Managed Grafana - Grafana v10.3.4 (5bde27379c)

[aangelisc]

Hi @MSDkuznetsov, thank you for the report. I can confirm I've replicated the behaviour in Grafana. However, I also see issues when executing this query in Azure directly:

Are you able to confirm if this is an Azure issue?

[MSDkuznetsov]

I see no issues from my side, works as expected. Based on the error it seems to me like it's some other error related to connection.

Hi @MSDkuznetsov, thank you for the report. I can confirm I've replicated the behaviour in Grafana. However, I also see issues when executing this query in Azure directly:

Are you able to confirm if this is an Azure issue?

[aangelisc]

Hi @MSDkuznetsov,

The actual underlying issue is that these queries aren't supported by the endpoint Grafana uses. The true error is:

Bad request: Control commands (starting with a dot '.') cannot be served from the query endpoint unless they are .show control commands.

I've added a task to improve the error messages so this is made clearer to the user.

[MSDkuznetsov]

Hi @MSDkuznetsov,

The actual underlying issue is that these queries aren't supported by the endpoint Grafana uses. The true error is:

Bad request: Control commands (starting with a dot '.') cannot be served from the query endpoint unless they are .show control commands.

I've added a task to improve the error messages so this is made clearer to the user.

Thanks, that makes sense !

[aangelisc]

Fixed by #822