pbix file size increases without reasons

[bloffet]

Hi all,

I've  built a report based on 2 csv files that I import as source.

• The first csv file is about 4MB, and contains +/- 12000 lines.
• The second csv file is about 4 MB and contains +/- 14000 lines

After importing the first csv file, the size of my .pbix file is 2.23 MB so this is normal.

After importing the second one however, my .pbix file size goes up to 77MB !!

I do not apply any transformation queries.

Do you have an idea on what could explain this behaviour ?

Thanks already

Benoît

[bloffet]

By investigating a bit more, I've seen that when I change a text field into a date format, my file grows (+/-18MB for each field transformed). Is this normal ?

[v-sihou-msft · Accepted solution]

@bloffet

When chaning the data type from "text" to "date", Power BI will build date hierarchy internally so that the file size increases. It depends on your data amount.

Regards,

[bloffet]

Thank you for the explanation.

This is a paramter that needs to be taken into account if you have a lot of date fields.