Forum Discussion

palunel's avatar
palunel
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper 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
      Icon for Microsoft Employee rankMicrosoft 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
        Icon for Helper I rankHelper 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?