Forum Discussion
creating measures take long time
Yes, again!
Whenever you create a measure, PowerBI reviews its dataset to see what could inflict the new measure.
Having an imported dataset of +1gb is not fun to work with.Is working with DirectQuery a possibility? This wil only load the data you actually use.
The reason is your dataset is way too large.
If you are working with a database, write some smaller queries to aggregate your data.
Thanks RobbeVL , but please note that it's not the measure execution time that is long, it the creation of the measures that takes a very long time. The same thing whenever I change a measure.
Imaging creating a measuer like below:
foo = true()
Creating this very simple measure takes 3-4 minutes all together. Yes I know my dataset is large, but there are reasons for that and we are looking into both aggregations and other teqniques to decrease the size
Yes, again!
Whenever you create a measure, PowerBI reviews its dataset to see what could inflict the new measure.
Having an imported dataset of +1gb is not fun to work with.Is working with DirectQuery a possibility? This wil only load the data you actually use.
Thanks RobbeVL ,
Yes I can understand validation is needed, but I guess review is not all that happens. If you e.g. crates a calculated table that in one of the columns generates random numbers, you will see that each time you create a new measure (could be as simple as Measure=1), the values in the random column are re-calculated. I can't see why this is happening, and if this is part of the reason that it takes a long time to create new measures I guss it's something that Microsoft can do better
I agree and would add this is not really acceptable. I would question the idea that anything larger than 1 gb is large. I've already cut down my facts to only a few years with the pbix down to 800k (was 1.5 gb) and still adding a measure takes minutes each time. We do this same thing in SSAS and it's instantaneous. Why is PowerBI desktop so much slower than visual studio with SSAS? btw.....I'm running the same terminal server to do both SSAS and PBI desktop.
