Forum Discussion
Advocate IIIcreating 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.
Impactful IndividualThe reason is your dataset is way too large.
If you are working with a database, write some smaller queries to aggregate your data.
- pade
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
- RobbeVL
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.
- pade
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
