Forum Discussion
Project doubles in size when creating dimension tables
I have one large data set (300MB about 700k rows). I would like to make a series of dimension tables to reduce the size. My process has been to duplicate the original query, remove the columns I ...
Hi,
Thanks for the solutions Anonymous and Joe_Barry provided and i want to offer some more information for user to refer to.
hello Anonymous , based on your description , you can consider to use calculated table to create the demension table in desktop. such as
Table=summerize(table,[index]...)
You can refer to the following link about it.
Using calculated tables in Power BI Desktop - Power BI | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.