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 ...
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
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