Blank cells in Power Query, data existing in original source

Dear excel gurus of the web,

Apologies in advance if this is a repost but my reserach thus far was futile, therefore I believe I may be the first one to raise the issue here.

...

excel query fail.png

I am using Excel Power Query Editor to import multiple, identical tables, from multiple, identical excel files into one master excel file. This works well for most tables (each table uses a unique query) but fails for one of them.

I am ataching a screenshot of this Query Editor, where you will see some of the values in the RAG Status column are "null" and in fact, in the original files, they are not.

This really is a mind-blower for me right now, because I see no reason for it to be happening! Please share your expertise!

Many thanks,

K.



P.S.

*In the original file this column "RAG Status" takes data from another sheet which has Data Validation so the user is able to select either "Green, Amber or Red". However i don't think this is a problem as the Query is actually displaying most of these selections and they are and only displaying "null" for a few of them.

Hi, Alan,

thanks for your reply. My case requires that I upload a total of 6 excel file - 1 file is a query of the other 5. I have a problem because the website doesn't allow me to upload my rar file - it says "invalid file" could you elaborate on how to proceed?

p.s - I tried sharing the link with the uploaded filed but I'm "too new" to do it still.

BR,
K.

Hello dear,

I have a similar issue in query.
Did u find the solution for this ?

Jose