Forum Discussion
Solved
Datamart report slow
Hi All, I have been playing with the Datamarts feature, has anyone else noticed it's really slow? I've recreated a portion of an existing dataset as a datamart, (reports against the original ...
yes this is because the datamart using DirectQuery to the underlying database (SQL Server), while the other report uses the Power BI Vertipaq engine which is super fast.
Hi all,
MS has released an update to dataflows that appears to indicate better performance, has anyone noticed any improvements? (is there a way to check if the new "auto import" feature is on?)
https://powerbi.microsoft.com/en-us/blog/whats-new-in-datamarts-august-2022/
My tests still seem really slow, if I connect to the datamart it's worst, connecting directly to the datamart dataset is slightly better but still not great and nowhere near as good a stand import dataset.