Difficulty in visualizing plots in Grafana Cloud: Query data error

Grafana Cloud
,
1

Hi!

I have been created successfully a data source in Grafana Cloud

first_Grafana_dashboard_38
first_Grafana_dashboard_38721×807 24.8 KB

Then I have created a plot in a dashboard by copying a successfully tested plot on my Grafana local instance:

SELECT
  time_stamp AS "time",
  mvalue AS "temperature"
FROM periodic_measurements
WHERE
  $__timeFilter(time_stamp) AND
  room_id = 0 AND metric = 1
ORDER BY 1

However, I am not able to see the plot in Grafana Cloud.

I get the following error:

Query data error

Object

status:500

statusText:"Internal Server Error"

data:Object

message:"Query data error"

config:Object

url:"api/ds/query"

method:"POST"

data:Object

requestId:"Q100"

retry:0

headers:Object

hideFromInspector:false

message:"Query data error"

Any hints?

Thanks,

Bernardo Di Chiara

2

Hello,

I see you’re hitting a server error 500 in the return. It’s likely that the settings on your service are not allowing it to communicate with our Grafana Cloud endpoints and make your mySQL data available to your Grafana. You’ll want to try allowlisting the “Hosted Grafana” IPs noted here: List of source IPs to allowlist | Grafana Labs on your server’s security settings.

3

Hi!

Thanks for your answer!

I added the IP addresses to the Timescale Cloud service configuration as you suggested but I still get the same result.

4

Hi!

The problem was the existence of a rule with an empty math expression. By removing that rule, the SQL query has been run successfully.