Expression error Prometheus with Bigquery

[eduardocosta]

Hi folks!

I’m developing a dashboard with mixed datasource (Prometheus and Bigquery). So, when I try to an Math Expression, I get the error below.

status:500
statusText:“Internal Server Error”
data:Object
message:“Query data error”
traceID:“”
config:Object
url:“api/ds/query”
method:“POST”
data:Object
requestId:“Q105”
hideFromInspector:false
retry:0
headers:Object
message:“Query error: 500 Internal Server Error”

I could to do this expression on the Transform’s tab but I need send alerts to my slack channels and I can’t to do this if I transform the data on the tab.

Grafana version: v9.2.4 (64017e8ca6)
Datasources: Prometheus and Google BigQuery

Please let me know if I can help you with more informations.

[grant2]

Welcome @eduardocosta
I believe it might work in the Alerts section if you do the following:

Query A: your Prometheus query
Query B: your Google BigQuery query
Expressions for C and D and E as follows:

[eduardocosta]

Hi Grant2, I did this but I saw the same error message:“Query error: 500 Internal Server Error”

[grant2]

If you remove expression E, then run the queries, are there any errors produced for A, B, C or D?

[eduardocosta]

Hi Grant2,
Yes, I got the same error.