Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello all,
I have a folder that has 5 distinct csv files. THese 5 files are 5 different tables so i do not wish to combine/merge them. How do I import them as 5 different tables?
I connected them to folder but every csv file has binary type which can only be combined.
How to go ahead?
Hi @Swam80
You said you had 5 files - you have many more than that?
The folder connector is designed to load multiple files of the same structure - that is they have the same tables in the that you want to append together.
If you have lots of files with different tables in them, so you don't plan to join them all together, then the folder connector isn't the tool you need.
If you do use the Folder connector, you can click on the Transform button during import (as opposed to Combine and Transform) and you'll get a list of files in that folder. The first column will be the binarty content of the files.
From this point you have to decide what you want to do. What is the purpose of loading all these files?
If you have different internal structures in the files, then any query/steps you write are particular to that file(s) structure and won't work for anything else.
Phil
Proud to be a Super User!
At present I have 5 files, but in general if we have many tables, then what is the alternative to manual loading is what I wanted to know. Every table has different structure.
I thought about one way, if i right click on the binary part and select add as new query then I can get individual queries for every binary i.e table. But again that would be a manual task. So can we write a custom function which will do it for every row which is binary ?
That would be for any transformation that Iwould have to do right. Here it would only be to load it as table. If you know a way out then kindly suggest,
Loading it as a table is a transformation. As each file is different the name and structure of the table(s) in the file will/can be different. So the process of 'simply' loading the table from a file will be different for each file.
Phil
Proud to be a Super User!
Hi @Swam80
Don't use the folder connector. Import each file as its own separate file/query. Just use the Text/CSV connector.
Phil
Proud to be a Super User!
But what if i have many files? It will be time consuming to manually load each and every file
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
21 | |
20 | |
13 | |
13 |