Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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
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
I am pretty lost on where to go from here so any and all help would be appreciated.
Thank you,
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.