Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power BI Desktop is So Slow Developing Making Model Changes

I am working on a Power BI model using Power BI Desktop and it is very very slow... Renaming a column, adding a folder structure, changing a format..... Every change made brings up a message saying...
Need Help
tobimax's avatar
tobimax
New Member
6 years ago

I'm having the same issue with a model of 10 Tables and a PBIX size of 193 MB and it's excruciating. 10 seconds every change. It’s slow creating hierarches, specifying folders, creating measures. It’s in total contrast to the Power Query Editor which is snappy and quite fast. It’s like 2 different apps.


I have gone from using SSAS and Tabular Editor to this and it’s shockingly less productive.


Anyone manged to find a solution to it?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I will second what the others are writing. It takes forever to update. I filter my data to a bare minimum when designing but it still takes for ever AT... EVERY.... STEP...

 

My minimum file is a very small (23 rows and 18 columns) online Sharepoint excel file imported via Sharepoint Folder. It is absolutely killing me (lots of stressball-squeezing). I am on dec 2019 version of Power BI Desktop.

 

  • tobimax's avatar
    tobimax
    New Member
    6 years ago

    I got better performance by turning off all the auto detect features in settings. You will need "Auto date/time" on if you do not have a designated Date Table/Dimension.

     

    Regards

     

    Toby