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 'working on it' with a little dial/circle that ticks around for 10 secs for each and every change.

It shouldnt be like this takes for ever to make changes to a model....

 

Need Help

8 Replies

  • 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


  • vanessafvg's avatar
    vanessafvg
    Community Champion
    6 years ago

    Anonymous  is this an imported model?   or are you connecting directly to a data source.   I would check the memory on your computer to see if this is affecting it.  If you give more information about how you are doing this that woud be helpful

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi yeah its an imported model

      Of got 16GB of memory memory is about at 60% 

      Id get another 16GB if that would fix the problem but Im not sure its memory related?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Theres about 70 tables in the model its on top of a data warehouse basically

        Lots of DAX measures...

        The model has gone through a number of iterations and restructuring/renaming

        It just seems it takes a long time/is slow when making/applying changes, also in creatign new DAX measures also

        Very annnoying as basically data modelling is an iterative process with additions/changes continually made and with this poor perfromance issue takes a long time

         

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    What is your data source? Is that possible using Direct query instead of import?