Forum Discussion

kevjay74's avatar
kevjay74
Frequent Visitor
8 years ago

data recognition on a xls file

Hi   I have some data I'm trying to import through the power Bi Desktop, but for some reason as a .xls file the query editor is not recognising the text  in column E so I can't filter by the col...
kevjay74's avatar
kevjay74
Frequent Visitor
8 years ago

Hi MFelix,

 

I'm using 2.53.4954.481 64-bit (December 2017) version. Which I think is latest version. 

 

I enclose a link to the file I'm trying to view in the query window. For me, Column E or Column 5 in power query is not appearing.

 

https://www.dropbox.com/s/5179nkqjjusra96/Incorrectv2.xls?dl=0

 

 

thanks

 

 

 

kevjay74's avatar
kevjay74
Frequent Visitor
8 years ago

Hi was wondering if anyone had any idea on this?. It seems strange that it's just the .xls format. I thought Power BI looked at the first 200 rows to define a data type, so strange that it's appering as a number. Anyway, any assistance on this would be much appreciated.

 

thanks

 

Kevin