Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Auto-refresh newest csv/xlsx file from folder

Hi all   apologies if this is already covered in another community post - I couldn't find a full answer to what I'm after.   I have a Power BI report which takes information from multiple spreads...
Dataflow
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anonymous,

    Folder connector can auto-refresh to append all folder files, if new files add to folder, they will be updated to your table records after folder refresh.
    Currently, power query will cache the previous table structure in query steps. You need to confirm your file structure does not change or manually fix these not match fields in query steps to prevent 'key field not match' issues.

    BTW, power query combine functions not able to handle different type of files, I think you need to write a custom function to recognize the file type and use the corresponding connectors to get data and return result tables.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous,

Folder connector can auto-refresh to append all folder files, if new files add to folder, they will be updated to your table records after folder refresh.
Currently, power query will cache the previous table structure in query steps. You need to confirm your file structure does not change or manually fix these not match fields in query steps to prevent 'key field not match' issues.

BTW, power query combine functions not able to handle different type of files, I think you need to write a custom function to recognize the file type and use the corresponding connectors to get data and return result tables.

Regards,

Xiaoxin Sheng