Blog Post

Power BI Community Blog
2 MIN READ

Automatically update data according to the date in the file name | Author: Janey Guo

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Scenario:   Each day or Each month, an excel file with new dates’ date will be added. The data structure is the same, only data is different. How to automatically obtain the data of a new file in p...
Updated 5 years ago
Version 2.0
Excel
M code
Power Query
SharePoint
tips & tricks
Anonymous's avatar
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, Thanks for sharing this. Could you also please let me know how to refresh/load only the newly added files to the folder instead of refreshing the whole folder? 
In my case, I want the old data to be there and refresh and load only the newly added file data, as refreshng and loading the whole folder is time consuming. Also I tried the incremental refresh option of Power BI, it doesn't seem to work probably beacuse these are Excel files.