Bloating power bi file size?!

[myrmellom]

How can a simple import of a small excel data sheet (348k xlsx file) that consists of just 33 columns and 1600 rows become a whooping 77 mb pbix file, even before anything else is done but connecting the data. Is it supposed to be like this? I suspected both formats to hold adequate file compression levels...

[myrmellom]

Thank you for the swift reply. But can you explain what you meant by repo steps? Plain connection to the excel sheet without further steps causes the file size increase. Even by just doing the "Get data" operation without additional parameters, and plainly take the file into the PBIX, this is the result. I enclose the content from advanced editor, perhaps it will shed some light on the steps: let Source = Excel.Workbook(File.Contents("H:\DATA\00 HIK\SKU\BPI\BTM\03 INPUT CONTIKI\Kilde CONTIKI.xlsx"), null, true), #"Kilde CONTIKI_Sheet" = Source{[Item="Kilde CONTIKI",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(#"Kilde CONTIKI_Sheet"), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"CONTRACTID", Int64.Type}, {"AvtaleNr", type any}, {"Beskrivelse", type text}, {"Status", type text}, {"Registreringsdato", type any}, {"Tildelingsdato", type date}, {"Signeringsdato", type date}, {"Startdato", type date}, {"OpprinneligSluttdato", type date}, {"NySluttdato", type date}, {"Makssluttdato", type date}, {"ÅpenEndedAvtale", type text}, {"Kategori_L1", type text}, {"Innkjøpsgruppe_L2", type text}, {"Anbudspakke_L3", type text}, {"ProduktGruppe_L4", type text}, {"Avdeling_HIK", type text}, {"Innkjøpsrådgiver", type text}, {"Forvalter", type text}, {"Avdeling", type text}, {"MotpartPartner", type text}, {"OrgNr", type any}, {"Katalog", type text}, {"Volumreduksjon", type any}, {"Kvalitetsforbedring_i_totalleveranse", type any}, {"ØktStandardisering", type any}, {"ForbedretProsess", type any}, {"Kontraktsverdi 1: Utlyst verdi (0 for ubegrenset)", Int64.Type}, {"Kontraktsverdi 2: Faktiske tilbudspriser", type any}, {"Avtaletype", type text}, {"Kontraktsrelasjoner", type text}, {"Kontraktsserie", type text}, {"AkkumulertSpend", type number}, {"Prosedyre", type text}}) in #"Changed Type"

[myrmellom]

Thank you for a very swift handling! 🙂

[myrmellom]

I have now enclosed the file in an email. For your information, I am on PBI version 2.35.4399.381 64-bit (may 2016)

[chass]

Depending on the data modeling steps this could easily happen and is to be expected. Please include a set of repo steps. Thanks Chuck

[chass]

Just created an Excel file with 16000 rows and 35 columns. After importing and creating a report with 4 visuals the file size was 1.34 mb Thanks Chuck

[chass]

For tracking issues this is defect 7811383

[chass]

Hello Tony, Thanks for sending through your excel file. It appears to be an issue with the data/time columns We will track with a bug but you can work around it by unchecking this time intelligence box on data import. This is found under: File>Options/Settings>Options>Data Load> Uncheck the "Time Intelligence" Auto Date/Time Option THEN import your file Chuck

[chass]

Received your file and see the size increase...let me look into it

[chass]

Hello Tony, If you can send me the Excel file (perhaps with dummy data if it is sensitive) i will take a look...but my Excel files are not doing this. Thanks, Chuck Chass@microsoft.com