Forum Discussion
Values show null when I import data using the folder feature
It looks like some of your files have different column names (spaces at the end?) so PowerQuery is not able to align them all together.
Once you fix that, they should all come in correctly.
This type of error happens for two reasons:
- The table or sheet names are different.
- The column names are different.
By correcting these, update and it's done.
If this response helped you, please mark it as 'Solution'.
Hi BiCp81 - It is a common issue with Power BI when combining data from multiple files.Make sure the data types for each column are consistent. You can do this by selecting the columns in Power Query and changing their data types to match.
Solved: Date data showing as "null" despite source data ha... - Microsoft Fabric Community
Solved: Null Values when Get Data from Folder - Microsoft Fabric Community
Hope the above solved and details helps.