Forum Discussion

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

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?

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.
  - palunel
    Helper I
    9 years ago
    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.