Forum Discussion
File size
Hi all, My excel file(source fie) size is 28mb and pbix file size is 80mb.I need to reduce my pbix file size. Suggest some idea.
Hi Sujith,
Radacad has some good recommendations for this. Might be a good place to start: How to Reduce the Size of Power BI file in a few Steps - RADACAD
Regards,
Tim
timg @Already I tried with uncheck the date/ time option and based on the client requirements, they don't want to remove any columns in the report.
Is there any possible way to reduce power bi size.?
Hi Sujith,
Most options will involve changing/optimizing your datamodel. If no columns can be removed you could still look at:
- reducing the number of rows in each table (e.g. instead of loading multiple years of data, just loading the current year)
- If you have calculated columns, you could try moving those to Power query instead
- Limit the number of unique values within columns that currently have many unique values (e.g. by grouping them in Power query or the source)
Regards,
Tim