Forum Discussion
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
4 Replies
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?
Hey!
Yes - it is possible. It should be the section that reads "OneDrive for Business experience":
It provides the set of instructions on how to accomplish a connection to that folder in OneDrive for Business and not necessarily to a specific file. The rest of the article does talk about connecting to a single file, but I understand thats not what youre after
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.
