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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
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.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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