power query reads text string incorrectly

[palunel]

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

[parry2k]

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]

The problem actually manifests iteelf when I change the type to text! It must be text.

[Eric_Zhang]

---

@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]

---

@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?

[Eric_Zhang]

---

@palunel wrote:

---

@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?

---

You can upload it to a network drive, such as Onedrive or Google drive and send the link in a private message if you don't like it being public.

[Eric_Zhang]

@palunel

Thanks for sharing the excel. I can reproduce the same issue. I'll escalate  this to the product team and would post back if I get any update.

As a workaround, you can try to round those values and change them to text.

[palunel]

---

@Eric_Zhang wrote:

@palunel

Thanks for sharing the excel. I can reproduce the same issue. I'll escalate  this to the product team and would post back if I get any update.

As a workaround, you can try to round those values and change them to text.

---

Thanks, it kind of works problem is that text values that should be "1.010" ends up as "1.01".  I can sort of fix in Excel before importing into PowerBi so will continue with that until the fix is there.