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
Yamshay
Frequent Visitor

Extracting CSV tables from a zipped folder in SharePoint

Hello!

 

I am facing interesting issue that I can not figure out how to resolve. I am attempting to dynamically extract CSV tables from a zipped folder in SharePoint. The issue is that when I attempt to Combine the extracted CSV tables, thousands of blank values are added to the data. However, when extracting a single CSV table, no blanks appear. Does anyone know of a way to dynamically extract multiple CSV tables and combine them without introducing blanks? Screenshots below of my process

power-query-csv.png

 

 

 

 

 

 

 

 

1. When selecting the "Combine" button (or using the Combine function in the ribbon) Power Query adds a bunch of steps to extract and combine each of the CSV tables within FileNames. However, somewhere during this process, thousands of blank values are added sporadically to the data. Screenshot below

power-query-combine-csv.png

 

 

 

 

 

 

 

 

 

 

 

2. When clicking the "Binary" value from the first screenshot, Power Query runs an extract function on that single file and converts it into the table that exist in the CSV. This extract does not contain any added blanks and populates correctly across any file I test. However, I can not find a way to have this Extract function account for multiple files in a folder. In addition, I don't know if there's a way for the extract function to handle a dynamic number of files. See screenshot below of the Power Query steps following clicking on the "Binary" value from screenshot 1

power-query-binary-csv.png

 

 

 

 

 

 

 

 

 

 

I am pretty lost on where to go from here so any and all help would be appreciated.

 

Thank you,

1 REPLY 1
lbendlin
Super User
Super User

When selecting the "Combine" button

 

Don't do that. Write your own code to process each binary via Table.AddColumn and then expand the resulting tables.

 

If you like more help please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

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.