Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everyone,
Over time I have created a Power BI model that has become quite extensive. Refreshing and filtering could be faster but it's acceptable. What is getting annoying is the time it takes to create/edit/delete columns and measures. I just now timed this and each of these actions take almost 2 minutes individually. This slows down development a lot.
My model size is just under 500MB and I have 96 active queries. Most of them have relationships and are somehow connected. I use a laptop with an i5-6300 HQ CPU and 32 GB memory. Allmost all queries I use are preset SQL statements without any further applied steps in the query editor. Most of them are fast. I do have a lot of calculated columns and measures in the model. Could that be slowing everything down or is it just inevitable for a model this 'complex'?
I seems likely that others have similar models so I would assume you have similar problems? Thought it would be interesting to read about some other cases. It's not just me right?
my model is about 300mb, 400 queries (every include 15-20-30 columns), any changing or creating of column, measure, link takes about 3-4-5 minites! awful...
Same here, not as slow as yours (also much smaller model - ~90MB), but every time you want to create a measure, apply measure changes, change formating etc.. it takes areound 10-20 seconds, which is super annoying given how many clicks are involved.
Did you manage to resolve this?
Thanks
Hi,
I am afraid it’s a truth that the Power BI will slow down if you have such a big model. I have had a test. My model is 327MB, 10 tables and very simple. It took almost 1 minute to add a column. I found the speed depends on the size of the table in some way. A table with 12 million rows is slow while a table with hundreds rows is very fast in the same model. May you should optimize you model. Please reference this article.
http://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques
Best Regards!
Dale
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
58 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |