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 swb128,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to MasonMA , danextian , Elena_Kalina and Abhilash_P for their prompt and helpful response
Just following up to see if the solutions or suggestions provided by community members were helpful in addressing the issue.
If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar