Forum Discussion
Increased data size after new date column
Hello,ribisht17 ,govind_021 ,Ritaf1983 and Gabry ,thanks for your concern about this issue.
Great advice from everyone!
And I would like to share some additional solutions below.
Hi,HR3038511 .I am glad to help you.
I'll just make some brief summaries of the suggestions made by other users, and I hope you find them helpful.
If you want to reduce the impact of data columns on model capacity.
You can start from the following aspects.
1. Reduce the number of dates as much as possible, and try to use integer or other numeric types to save them, in general using integer types to save data can make occupy a large percentage of memory reduction. (provided that it does not affect the use of the date field itself)
2. Turn off the auto date/time feature in Power BI Desktop.
This is one of the official Microsoft recommended ways to reduce semantic model memory.
URL:
Data reduction techniques for Import modeling - Power BI | Microsoft Learn
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian