Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Load different format files from folder

It should be a very simple question I believe, but I can't really get the answer. 

 

The question is I want to load multiple files at the same time by using "Get data -> Folder". However, those files I want to import are in completely different formats, and even their filenames are completely different (or I should say they don't share any columns).

 

For example, one file is "File A.csv", with 5 columns; another file is "Hello 123.xlsx", with 10 columns. I am expecting to see the final result would be loading two separate tables that can be seen in the "Fields".

 

I would be grateful if somebody can help answer this question.

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , As far as I am aware, you have add them separately as tables

 

or add folder ad filter similar type of files and then append binaries

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

You mean that "get data -> folder" this action can only import multiple same-format files, if they are in different format, then the only way to import them is to one-by-one import the files?

 

Hope I don't get you wrong.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Kudoed Authors