Dashboards and data source is provisioned correctly. Not able to Load Data into Provisioned Dashboards. I need to edit query and just add space character (query as such is not changed), Run Query. Apply, the dashboard panel works fine. I can’t save the Provisioned dashboard. What is the solution that refreshes and loads data into the panel (without query tempering). Please help.
Can you please share panel json file (redacted as necessary) of initial not working state? Better to see an example of what is not working.
Thanks in advance
Suleyman Kutlu
Thanks, snk! Json file attached.
Average Compliance Job-1725995973383.json (8.2 KB)
What’s happening: This provisioned dashboard is being loaded when Grafana container starts. Data source is also available. But, the data is not loaded when dashboard is clicked from Home->Dashboard. I would edit the panel, go to query and just add space any where in the query, Run query, data gets populated. On clicking Apply button, data is shown as well. It’s the very start of the provisioned dashboard, data is not getting loaded.
Any updates?
[quote=“paramsbindra, post:1, topic:131985, full:true”]
Dashboards and data source is provisioned correctly. Not able to Load Data into Provisioned Dashboards. I need to edit query and just add space character (query as such is not changed), Run Query. Apply, the dashboard panel works fine. I can’t save the Provisioned dashboard. What is the solution that refreshes and loads data into the panel (without query tempering). Please help.
[/quote] resolve the problem:
- Clear Cache:
- Sometimes, dashboards or queries might be cached, and clearing the cache can resolve issues with data not loading. Look for an option to clear the cache in your dashboard or data source settings.
- Check Query Configuration:
- Verify that the query used in your dashboard is correctly configured and does not have any syntax errors. Even if the query seems correct, there could be hidden issues.
- Update Data Source Configuration:
- Ensure that the data source configuration is correctly set up and that there are no connectivity issues. Sometimes reconfiguring the data source can resolve issues.
- Verify Data Source Permissions:
- Ensure that the necessary permissions are set up correctly for the data source. Lack of permissions might prevent data from loading.
- Dashboard Refresh Settings:
- Check if there are any settings related to auto-refresh or scheduled refresh for the dashboard. Configuring these settings can help ensure that the dashboard is updated with the latest data.
- Check for Errors:
- Look for any error messages or logs related to the dashboard or query execution. These messages can provide clues about what might be going wrong.
- Review Data Source Limits:
- Ensure that the data source does not have any limitations or restrictions that might be preventing data from loading into the dashboard.
- Consult Documentation:
- Refer to the documentation for your dashboard tool or data source for any specific troubleshooting steps or known issues.
- Support Request:
- If the issue persists, consider reaching out to the support team for your dashboard or data source tool. Provide them with details about the issue and any relevant error messages or logs.
By following these steps, you should be able to identify and address the issue causing the data not to load properly into your provisioned dashboard.
Thanks, Harry!
Also, I do not know why I see the following error message on my provisioned dashboard.
Error
upstream connect error or disconnect/reset before headers. reset reason: connection termination
I checked the logs and see the following message:
logger=authn.service t=2024-09-16T14:41:13.783929699Z level=info msg=“Failed to authenticate request” client=auth.client.api-key error=“[api-key.invalid] API key is invalid”
Welcome.
@paramsbindra your last errors seems like you have a credentials / authentication issue with your data sources. Can you check if your datasources are working properly ?
In Connections / Data Sources tab, click your datasource(s) and at the bottom there should be test button, test your connection if it is working…