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...
Need Help
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?

      • palunel's avatar
        palunel
        Helper I
        9 years ago
        Eric_Zhang wrote:
        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?

        I can.  How do you want me to get it to you?