Forum Discussion
Helper IColumn appearing as null when the source file is closed.
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!
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
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
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!