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

[Stacey_Griffeth]

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?

[Stacey_Griffeth]

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?

[DaviddYokley]

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. 

[miguel]

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

[miguel · Accepted solution]

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