Forum Discussion

Icon for Helper I rank

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...

Icon for Helper I rank

Helper I

9 years ago

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

Icon for Microsoft Employee rank

Microsoft Employee

9 years ago

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

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

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?
- Eric_Zhang
  Microsoft Employee
  9 years ago
  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
    Microsoft Employee
    9 years ago
    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.