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.
Dear All,
I still have the same problem over 2 years later. Is there a proper solution nowadays?
Thanks!
Just replying with some lernings.
Building larger datasets, use tabular editor
Even for smaller datasets, this is a problem if you have many calculated tables and columns. In that case, could you instead have used PQ for creating these calculated columns and tables? Yes... replacing a calculated table (based on another table) with a PQ table will most probably generate a slower ETL since PQ has quite a small cach and therefore will draw the same information a second time from the data source. Using PBI dataflows can help here in that case.
But... Doing all this work in a wherehouse or datalake is most time the best choise and then only do measures in PBI