Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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....
use the External Tools option with Tabular Editor - massively faster
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?
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.
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
Hi @Anonymous ,
What is your data source? Is that possible using Direct query instead of import?
@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
Proud to be a Super User!
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?
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
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |