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
Eric_Zhang's avatar
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's avatar
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.