Forum Discussion

minhvuong93's avatar
minhvuong93
Icon for Helper II rankHelper II
8 years ago
Solved

Append new Excel table into dataset without loading again old data?

Hi everyone, I've read a few topics on how to append data in PBI but still find it very slow/ So I have a large number of excel files like below and I imported into PBI via folder import (code as b...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi minhvuong93,

     

    I'd like to suggest you add some filters after get data from folder and before expand records, it will obvious increase the load performance.

     

     

    >>My excel have table header like below, These stay the same, but some months there were extra but unnecessary headers. 

    For this scenario, you can try to use Table.SelectColumns to instead RemoveColumns function to choose which columns you needed.(not need to care about randomly needless columns' name)

     

    BTW, folder connector not support incremental loading/refresh.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi minhvuong93,

 

I'd like to suggest you add some filters after get data from folder and before expand records, it will obvious increase the load performance.

 

 

>>My excel have table header like below, These stay the same, but some months there were extra but unnecessary headers. 

For this scenario, you can try to use Table.SelectColumns to instead RemoveColumns function to choose which columns you needed.(not need to care about randomly needless columns' name)

 

BTW, folder connector not support incremental loading/refresh.

 

Regards,

Xiaoxin Sheng