Forum Discussion
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...
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
Hi there
Currently when you refresh the data it loads all the data from your source location/files.
There will be Incremental refreshing coming to Power BI Pro, but that will only be for supported data sources and from my understanding Excel/CSV is not currently supported.
Currently when you refresh the data it loads all the data from your source location/files.
There will be Incremental refreshing coming to Power BI Pro, but that will only be for supported data sources and from my understanding Excel/CSV is not currently supported.