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.
Advocate IIIThanks 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
Impactful IndividualYes, 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.