Forum Discussion
Solved
Values show null when I import data using the folder feature
Hello, I have a folder with about 40 files using the same structure, one per day. When I import in power BI using the excel option the last file, I get all the values correctly put : Bu...
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'.
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'.