Forum Discussion
PBIX file size increasing
Anonymous you have many date/time columns in your model and each date/time creates a hidden calendar table, you can turn this off in options and once it is done, you will see the size goes down.
As a best practice, add date dimension in your model and use it for and time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools.
https://perytus.com/2020/05/22/create-a-basic-date-table-in-your-data-model-for-time-intelligence-calculations/I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Super UserAnonymous you have many date/time columns in your model and each date/time creates a hidden calendar table, you can turn this off in options and once it is done, you will see the size goes down.
As a best practice, add date dimension in your model and use it for and time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools.
https://perytus.com/2020/05/22/create-a-basic-date-table-in-your-data-model-for-time-intelligence-calculations/
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
parry2k , thanks for the suggestion!
It was as simple as turning off auto date/time option 🙂
We do have a date dimension marked as date table but we have it at the DB level.
Thank you very much,
Lucas