topic Re: Fabric - Data Flow Question for Sharepoint folder source in Dataflow

Fabric - Data Flow Question for Sharepoint folder source

gunjesh0310 — Thu, 27 Jun 2024 02:40:58 GMT

Hi All,

I have two questions related to Dataflow.

1. Can we create one Dataflow using multiple sharepoints folder files, means in one sharepoint folder we have multiple xls or csv files we have to use those file in one Data flow

2. if we are pulling multiple files from the same location, we could use one data flow and loop through them in Fabrics ?

is it possbile? if not , then what will be the solution.

Thank You,

Re: Fabric - Data Flow Question for Sharepoint folder source

ibarrau — Thu, 27 Jun 2024 13:20:37 GMT

Hi. If you are grouping many similar files like csv (same structure) on a sharepoint folder, you can combine them in a single table with dataflows. If you want to import many tables from different structure in a single dataflow, you can do it too. Give us more details if you have more info about the requirement.

Getting from folder examples:

Article: https://blog.ladataweb.com.ar/post/627427136962281472/powerbi-obtener-datos-de-una-carpeta-de

Video: https://www.youtube.com/watch?v=-XE7HEZbQiY

I hope that helps,

Re: Fabric - Data Flow Question for Sharepoint folder source

gunjesh0310 — Thu, 27 Jun 2024 15:06:46 GMT

Hi,

Thanks for replying, However I am talking in Microsoft Fabrics Dataflow not the simple power BI Data flow.

Thank You,

Gunjesh Joshi

Re: Fabric - Data Flow Question for Sharepoint folder source

frithjof_v — Thu, 27 Jun 2024 22:06:18 GMT

Many features are identical in Power BI Dataflow and Dataflow Gen2.

If something works in Power BI Dataflow, most likely it works in Dataflow Gen2 also.

If the files have the same table structure inside, you could try to follow these links:

https://learn.microsoft.com/en-us/power-query/connectors/folder

https://support.microsoft.com/en-us/office/import-data-from-a-folder-with-multiple-files-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4