Forum Discussion

manoplaeli's avatar
manoplaeli
Icon for Helper II rankHelper II
9 years ago
Solved

Data model increase after import from excel

My PBIX file has increased from 8 MB to 89 MB after import the data from Excel to Power BI. Is this normal or there might be something wired in my data? This is just only right after I imported the d...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    manoplaeli,

    Which date do you refer to? You can delete the Vlookup columns in Excel, then import data from Excel to Power BI Desktop and recreate VLOOKUP columns using DAX.

    Regards,

manoplaeli's avatar
manoplaeli
Icon for Helper II rankHelper II
9 years ago

Anonymous

 

Hi Thank for reply and sorry for delay response. My Excel file is 8 MB and I have deleted all Vlook up column. The PBIX file reduced from 80 MB to 50 MB. Unfotunately I can't share the Excel file due to data protection reason.

 

I found thta the date causing the file increase. I assume that is because the hierarchy funtion that maltiply the nubmer of data. Is there any way to work around with this file size?

 

Best,

Manop

Anonymous's avatar
Anonymous
Not applicable
9 years ago

manoplaeli,

Which date do you refer to? You can delete the Vlookup columns in Excel, then import data from Excel to Power BI Desktop and recreate VLOOKUP columns using DAX.

Regards,