Forum Discussion

minhvuong93's avatar
minhvuong93
Helper II
7 years ago

Best way to Optimize get data from Excel files

Dear all - I am new to PowerBi. Each month I have a heavy files of Sales report stored under Excel files , consisting of multiple regions per month . Approx. 70MB per files per region. I used Get d...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

minhvuong93,

I would recommend you append all data into a single table in Power BI Desktop Query Editor. Then for each monthly  table(201806,201807,201808,etc.), you can disable "Enable load" option for them in Query Editor, this way, these tables will not be loaded into data view of Power BI Desktop. 


Also you are able to get Sum of Total Volume for each OutletCode per month in the appended table.

Regards,
Lydia

minhvuong93's avatar
minhvuong93
Helper II
7 years ago

Anonymous 

I tried append data but when PBI create the append table , it reloaded all the excel files again when I click apply query changes.

I disabled already the 3 modeling table in the query editors. How come it still need to reloaded from the excel files again 

And this took forever...

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    minhvuong93,

    It will cost time when the append table contains large amount of data and columns. Please disable the highlighted options in your PBIX file and check if you can apply change.



    Regards,
    Lydia