cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
palunel Helper I
Helper I

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 query however reads the following:

 

Capture.JPG

 

Huh?!  Not very useful.  Any suggestions would be grand.

 

Paul

7 REPLIES 7
Super User IV
Super User IV

Re: power query reads text string incorrectly

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. 






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





palunel Helper I
Helper I

Re: power query reads text string incorrectly

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

Re: power query reads text string incorrectly


@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 Helper I
Helper I

Re: power query reads text string incorrectly


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

Microsoft
Microsoft

Re: power query reads text string incorrectly


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

Microsoft
Microsoft

Re: power query reads text string incorrectly

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

Capture.PNG

palunel Helper I
Helper I

Re: power query reads text string incorrectly


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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors