i recently replaced my data source which is a higher environment database, so the new data source has the same tables and columns as the previous data sources. I created new data sets using the new data source and replaced the datasets in my analysis. I am able to see visuals in my analysis but on my dashboard I am getting the error “cannot access data for this visual” what could be the issue ?
Cannot access data for this visual, getting this error on dashboard but able to see data on analysis
Hi @izzycs
Issue with visuals on your Quick Suite dashboard showing cannot access data for this visual, even though they appear correctly in the analysis. Since you recently replaced the data source with one from a higher environment (same tables/columns/datatypes) and updated the datasets, this is likely related to how the dashboard syncs with the new dataset.
When creating your new datasets, are you using SPICE (import) or Direct Query? If it’s Direct Query, the query might be timing out or taking too long against the new database. I recommend,
- Editing the dataset in your analysis and switching to/publishing with SPICE for faster, cached access.
- Republishing the dashboard afterward to fully sync the changes.
Please refer to the following Quick Suite documentation and community post this might be helpful for you.
it was because dashboard was not published