Forum Discussion
Blanks showing in table visual
swb128 Hi, happy to hear you found the issue! "Power Query analyzes the example file (by default, the first file in the list) and determines the correct file connector to use to open that file."
https://learn.microsoft.com/en-us/power-query/combine-files-overview
So It builds transformation steps (like types) based solely on that file. And those steps are then applied to all other files, even if they are different or leading to missing or null values like in your ListPrice column.
I would go back and inspect csv data in excel or notepad before I load them in power query, identify one of the incorrupt ones and use it as the first file.
Not sure if there's a better or automated way. Maybe other people can advise?
Hi Mason,
I tried your suggestion using the IsBlank function and found the issue! Thanks! I have 5 csv files that are being used and I did 'Combine & Load' and made the 5 CSV files into 1 table. However, looking at the Table View, one of the CSV files seems to have blanks for the 'ListPrice' column. However, when I look at the original CSV file, there is data in the 'ListPrice' column. Somehow, the data got wiped out in that column. How can that be?
Is there an easy when of reloading that 1 CSV file into the Combined table?
swb128
- MasonMA
Super User
swb128 Hi, happy to hear you found the issue! "Power Query analyzes the example file (by default, the first file in the list) and determines the correct file connector to use to open that file."
https://learn.microsoft.com/en-us/power-query/combine-files-overview
So It builds transformation steps (like types) based solely on that file. And those steps are then applied to all other files, even if they are different or leading to missing or null values like in your ListPrice column.
Is there an easy/recommended way of getting the correct data loaded in? There are 1000 rows of data in the file, but just 1 column has been corrupted.
swb1
- MasonMA
I would go back and inspect csv data in excel or notepad before I load them in power query, identify one of the incorrupt ones and use it as the first file.
Not sure if there's a better or automated way. Maybe other people can advise?