Forum Discussion

itchyeyeballs's avatar
itchyeyeballs
Impactful Individual
4 years ago
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 ...
Need Help
  • GilbertQ's avatar
    GilbertQ
    4 years ago

    Hi itchyeyeballs 

     

    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.

itchyeyeballs's avatar
itchyeyeballs
Impactful Individual
4 years ago

Hi, we are using a star schema.

 

As a test I lined up two instances of PBI Desktop, one using the original data model and one using the new datamart (both identical in terms of tables, joins and import modes).  I created identical (simple) matrix visuals and tried to expand the same row in each version of the report.

The original data model has an instant reaction every time, the datamart version shows a spinning loading icon for at least 5 seconds (sometimes more)

GilbertQ's avatar
GilbertQ
Super User
4 years ago

Hi itchyeyeballs 

 

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.