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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
ThomasM
Frequent Visitor

Get Data - Folder Issue

Hi All

 

I am trying to read multiple files from a folder using the Get Data - Folder Selection.

 

These multiple files  all have column headings and the problem comes when the column headings become part of the data values.

 

Is there an option to ignore the column headings from second file until the last one?

 

Thanks,

Thomas

 

 

1 ACCEPTED SOLUTION
BhaveshPatel
Community Champion
Community Champion

Hi @ThomasM

 

You can filter those values to remove the headers pulled out with each of your files.

 

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

1 REPLY 1
BhaveshPatel
Community Champion
Community Champion

Hi @ThomasM

 

You can filter those values to remove the headers pulled out with each of your files.

 

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors