Skip to main content
Microsoft Idea

Power BI

Completed

"Folder" connector for Dataflows

Vote (79) Share
EightySix's profile image

EightySix on 08 Nov 2018 20:39:02

I would like to be able to create an entity by combining multiple flat files (i.e. csv) in a folder located on a local network.

Administrator on 14 Jun 2021 18:06:07

SharePoint folder exists in dataflows - https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder

Comments (12)
EightySix's profile image Profile Picture

Anton Fritz on 05 Jul 2020 23:39:02

RE: "Folder" connector for Dataflows

Folder connector is one of the connectors you can currently use in dataflows by copying and pasting the M query into a blank query.
For more details checkout this article:
https://docs.microsoft.com/en-us/power-bi/service-dataflows-data-sources#connecting-to-additional-data-sources

EightySix's profile image Profile Picture

Ian Halliday on 05 Jul 2020 23:34:36

RE: "Folder" connector for Dataflows

I would love to be able to do this. A great time saver, ideally with CSV held in Sharepoint.