Forum Discussion

bloffet's avatar
bloffet
Frequent Visitor
9 years ago
Solved

pbix file size increases without reasons

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 +/- 140...
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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's avatar
bloffet
Frequent Visitor
9 years ago

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's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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's avatar
    bloffet
    Frequent Visitor
    9 years ago

    Thank you for the explanation.

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