Column appearing as null when the source file is closed.

[e9801591]

I am combining several excel files from a folder. The problem happens is that one colmn which contains unique ID of the record shows up as null when the source files are closed.

The only way that the data shows up is when i literally open all source files (which is not practcal because I have a lot!) and Refresh preview in Power Query Editor. The files need to be kept open for the actual values not to show up as null.

I hope someone can help me since I really don't know how to address the issue.

Thank you!

[e9801591 · Accepted solution]

Thank you for the quic reply. Here is the file .

It's a work in progress as I am still learning so this will still be definitely cleaned up and optimized 😅.

The column 'dealer id' becomes blank in in queries 2, 3, 6, 7 and Dealer Base. 

Appreciate the help.

[Anonymous]

Hi there - 

Could you share the sample PowerBI file you have for this please? I think I may have a solution for this, but wanted to check your file before I can comment.

Regards

E

[e9801591 · Accepted solution]

Thank you for the quic reply. Here is the file .

It's a work in progress as I am still learning so this will still be definitely cleaned up and optimized 😅.

The column 'dealer id' becomes blank in in queries 2, 3, 6, 7 and Dealer Base. 

Appreciate the help.

[e9801591]

Maybe just to simplify the issue. Tried connecting to just one source file. This file has 3 columns, ID, name, and amount. When i load the data, the column "ID" disappears. If i open the source file and refresh, only then will the column ID appear. In short, column values become null when the source file is closed and only appears after refresh when i keep the file open.

[e9801591 · Accepted solution]

Was able to to find the issue. My Excle source file version is 1997-2003 .xls. I converted the file to a newer version .xlsx and problem solved.

Thanks!