Automated refresh with new data's from a folder

[Anonymous]

Hello everyone, 

I'm building a PowerBi to help a colleague to monitor the use of certain servers. To do so, he uses Excels sheets. I have already built the graph and put selection options as he wants.

My question is the following: is it possible to automate the addition of new excel sheets? My colleague is very bad with PowerBi, so I would like to know if there is a way to automate the addition of data, when new excel reports will be available in the future.

Thanks all

[amitchandak]

@Anonymous , refer if these can help

https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482

https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482

https://www.poweredsolutions.co/2020/01/19/incremental-refresh-for-files-in-a-folder-or-sharepoint-power-bi/

[AllisonKennedy]

You can use Get Data > From Folder and anything in that folder will be pulled into the report.

This article should help in updating the code so it works for OneDrive for business, but you can use any folder.

https://radacad.com/power-bi-get-data-from-multiple-files-in-a-folder-on-onedrive-for-business-no-ga...

other link for reference https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-combine-binaries