Cannot access data for this visual, getting this error on dashboard but able to see data on analysis

[Xclipse]

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.

Best practices for Amazon QuickSight SPICE and direct query mode | Amazon Web...

Cannot access data for this visual

Hello @joNic, there have been a few occasions where I have replaced a dataset like that on a dashboard and it did not maintain my calculated fields. Is it possible that calculated fields required for the visuals are not showing and that is why the visuals are displaying an error? If not, are you ignoring any of the fields from the original dataset when you map the new dataset as a replacement? Those are the only issues I can think of for this if the dataset is working as expected in a new analy…