Forum Discussion
Solved
OneDrive for Business as data source - current and future Excel files
I want to use a OneDrive for business folder as a source, where all current and future Excel spreadsheets in that folder are ingested into the data flow. Is this possible?
Hi
Yes - this is possible. You can read more about how to make this possible from the link below:
SharePoint and OneDrive for Business files import - Power Query | Microsoft Learn
HI miguel I might be misunderstanding, so please feel free to correct me. When I read the link, it looks like I would have to select which files in the OneDrive folder to add to the data flow. This folder automatically receives a new file every day, so I'm looking for a way to configure it such that all current and future files are automatically included. Is that possible?
Yes, you can typically use a wildcard in the file path, like "OneDrive/YourFolder/*," to automatically include all current and future files in your data flow.