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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
UsePowerBI
Post Prodigy
Post Prodigy

How to load multiple files into separate worksheets?

Hello

 

How can I open c:\a.txt to worksheet A and c:\b.txt to worksheet B?

 

Obviously the above is to be done for many files so I need a neat way to do it and maintain a file list.

 

Thanks!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@UsePowerBI , worksheet ?

Do you want to import and append the same type of files from folder?

 

https://insightsoftware.com/blog/power-bi-load-data-from-folder/

View solution in original post

2 REPLIES 2
UsePowerBI
Post Prodigy
Post Prodigy

@amitchandak  not append, just load them to separate specified worksheets in Excel or PBI.

amitchandak
Super User
Super User

@UsePowerBI , worksheet ?

Do you want to import and append the same type of files from folder?

 

https://insightsoftware.com/blog/power-bi-load-data-from-folder/

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.