Charts in a dataset can make use of the in-database execution engine, while charts in a visual analysis are always run in the DSS engine.
All the "normal" charts are pushed down - i.e. ones that break down the dataset by 1 to 4 dimensions, and that display aggregations (AVG/SUM/MIN/...) over 1 to N measures. Therefore bar, column, area, lines, mix, pie, donut, pivot table, grouped bubble, XY bubble. And those that don't do it are: geo, scatterplot, boxplots, KDE