Forum Discussion
Automated refresh with new data's from a folder
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
2 Replies
- 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-gateway-needed
other link for reference https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-combine-binaries Anonymous , refer if these can help
