Power BI visuals loading slowly when connected to SSAS Tabular Model

[Anonymous]

We are experiecing significant delays with certain visuals on data connected to a SSAS cube.  The visuals being used are a simple table visual with three columns (two of those columns are DAX calculations).  The report does also have two page level filters and four visual level filters which could be causing the slow down.  Any suggestions on how to fix this issue?

[v-jianboli-msft]

Hi @Anonymous ,

You could use DAX Studio to evaluate and improve query performance. And you could improve Power BI performance through the following ways:

1.Turn off auto date/time

2.Remove unnecessary columns

3.Optimizing the data model

4.Reducing the number of values but not the information

5.Reducing precision

6.Choosing measures over calculated columns

7.Optimize your DAX

To learn more details ,you could read the following articles:

10 Best practice tips to improve your Tabular Model performance

HOW TO IMPROVE POWER BI PERFORMANCE - PART I
HOW TO IMPROVE POWER BI PERFORMANCE - PART II
HOW TO IMPROVE POWER BI PERFORMANCE - PART III

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.