Null Values Imported from Excel

Hello!

I had a similar problem but in my case I was importing 12 files with the same structure and on one of them there was a column that only cointaned null values on power query.

This was because power query is REALLY case sensitive.

So I had:

11 files with column name = "EXample" (one of them was my "sample file" on "combine&edit")

and

1 file with column name = "Example"
SO
as the names are not exact matches (upper case vs lower case) power query doesn't extract the values

I just had to check that excel file and change the column name to the right one.

I hope it still helps someone!

Regarding this specific problem,  I didn't have any null problems importing.
I still followed this post answers: https://community.powerbi.com/t5/Desktop/Yearfrac-in-Query-editor-does-not-work/td-p/453998