Refreshing Power BI source data from folder

[Anonymous]

I have a folder setup as the source file for Power bi and keep adding a file per day. To get the updated information, I need to press the refresh button in Power bi desktop. While refreshing, Power bi updates/refreshes every single file (old files) which takes a long time. Is there a way I can refresh for current day's file only? Thanks

[Anonymous]

Check below link:

https://www.youtube.com/watch?v=8H9xM741hBQ

Kindly give kudos and mark this post as solution if it helped

[Anonymous]

Thanks Gaurav! I want to keep my previous day's files (information) and only update/refresh for today's file as I am maintaining a YTD trending visual. Any idea how that can be achieved? My folder contains over 500 day's files and refreshing Power Bi desktop everyday means connecting to every single file every day. Ideally I would only want Power Bi to refresh for current day's information. Thank you

[Anonymous · Accepted solution]

Interesting problem. I think we might need to dive into M query for this one. Go through this link. This might be it

[Anonymous]

Thanks Gaurav!