Data Not Showing Up - from Excel PowerQuery Pull

[wherdzik]

I am not sure what is happening but these numbers in EEID# and BILL ID# columns are not being picked up in powerquery.  They are showing u as blanks. Is this a data type issue? How do I fix this?

[v-stephen-msft]

Hi @wherdzik ,

Never mind, very glad to hear that you solved it by yourself.

If possible, please mark your reply as the solution. More people will benefit from it if they get the same problem.

Best Regards,

Stephen Tao

[wherdzik · Accepted solution]

I found the issue, it was my fault.  I filtered out the wrong row and then I filled down..I retraced the steps.  Sorry for posting.