I have a problem with dataset. I’ve created new dataset from aws athena view. Below you can find my analysis. Is anybody have similar problem? How to fix it? In Direct query mode, working correct. [Zrzut ekranu 2022-08-4 o 10.44.14]

Different analysis depending on Query mode (Spice, Direct query)

Michal September 10, 2022, 7:50am 3

There was an error in dataset. Some nulls were marked as NaN or NaT or etc. Quicksight SPICE couldn’t work with it. Check this out → Troubleshooting skipped row errors - Amazon QuickSight

Topic		Replies	Views
Quick Sight Direct Query vs SPICE Q&A data-source , quick-sight	1	524	May 18, 2023
Regarding the quick sight Q&A data-source , quick-sight	4	217	July 14, 2023
Change dataset from Spice to Direct Q&A spice , direct-query , quick-sight	7	2357	January 17, 2023
Can't import data from Athena to SPICE or use calculated fields on direct queries Q&A data-source , quick-sight	5	541	November 15, 2022
Facing issues with Join between two datasets? Q&A data-source , quick-sight , calculations	3	1304	August 19, 2022