Forum Discussion
Advocate IImport several excel files from a folder
Post PartisanHi bdymit,
I don't want to use the gateway for schedule refresh. Is there in the possibility to pull many excel file and schedule refresh in power bi service without using gateway?
Regards,
Arvind
Resolver II
If your excel files are saved in an on-premises location, you need a gateway (either personal or enterprise) to have any sort of refresh (scheduled or not.)
If your files are saved in SharePoint, then a gateway is not needed.
https://docs.microsoft.com/en-us/power-bi/refresh-excel-file-onedrive
Thanks,
Ben
- arvindyadav
Hi bdymit,
Can you please show me the steps I am using Onedrive personal I have uploaded one excel file in power bi desktop from drive What I have to do further if I want to add next excel file into that folder will that combine with previous excel and give me the entire data. If yes, Then please show me the steps.
Thanks & Regards,
Arvind.