Forum Discussion

palunel's avatar
palunel
Helper I
9 years ago

power query reads text string incorrectly

I have a table with a mix of text and decimal numbers that represent unique ID's.  Eg:  1.001, 1.002, P.23 etc.  I format these to text in the source (Excel) before importing into Power BI.  

 

The query however reads the following:

 

 

Huh?!  Not very useful.  Any suggestions would be grand.

 

Paul

Need Help

7 Replies

  • parry2k's avatar
    parry2k
    Super User
    9 years ago

    what you see data type of this column? Can you change it to "Text" to see if that makes a difference, I believe by default it is ABC/123. 

    • palunel's avatar
      palunel
      Helper I
      9 years ago
      The problem actually manifests iteelf when I change the type to text! It must be text.
      • Eric_Zhang's avatar
        Eric_Zhang
        Microsoft Employee
        9 years ago
        palunel wrote:
        The problem actually manifests iteelf when I change the type to text! It must be text.

        palunel

        Is it possible to share the source excel in your case for testing purpose?