Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have a large datamodel (200mb+) with star schema (dimensions and fact tables) and many many measures (500+).
In the beginning, adding measures was very quick but now it takes forever to make any changes to the datamodel.
Adding a measure takes around 1-2 minutes.
The same goes for other changes like, adding a calculated column or renaming columns.
Very frustrating to work with and takes forever to make changes..
Anyone else been experiencing something similar as the datamodel gets big?
PS: I've a i7-processor and 24GB RAM so computer power should not be an issue 🙂
Kristoffer
Same problem.
Any progress made?
Haven't delt with this problem on the desktop app, however thinking tabularly here I can advice the following:
1. reduce the size of the data model by pointing its data sources to something with a smaller footprint.
2. once you've added the new measure, publish it to a PBIT template
3. open the PBIT and point it to the full data set, this way you load the enitire data model in the final PBIX
It would be good to have a look at your trace files to get an idea what is it taking that long to load.
Thanks for the input.
I have tried to work with just a Power BI template (only metadata) and experience the same issue (slow, long wait) when adding measures / making adjustments to the data model. I think that the number of measures affects the time to add changes, but it doesn't make sense that it should! Same datamodel with less than 100 measures is really easy to work with and to make adjustments to. I get the similar experience developing SSAS tabular models.
Good idea to look at the trace file. I will do that.
Thank you
Hi @Anonymous. Unfortunately I had (have) same problems...
Regards.
Pavel
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |