Forum Discussion
minhvuong93
Helper II
Helper IIBest 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...
minhvuong93Helper II
Helper IIAnonymous
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...
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