topic OneDrive for Business as data source - current and future Excel files in Dataflow

OneDrive for Business as data source - current and future Excel files

Stacey_Griffeth — Fri, 27 Oct 2023 17:16:28 GMT

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?

Re: OneDrive for Business as data source - current and future Excel files

miguel — Fri, 27 Oct 2023 17:21:56 GMT

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

Re: OneDrive for Business as data source - current and future Excel files

Stacey_Griffeth — Fri, 27 Oct 2023 17:30:31 GMT

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?

Re: OneDrive for Business as data source - current and future Excel files

miguel — Fri, 27 Oct 2023 18:36:21 GMT

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

Re: OneDrive for Business as data source - current and future Excel files

DaviddYokley — Tue, 07 Nov 2023 06:41:33 GMT

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.