Data type changes after power query

[KriZo]

I have a column in Power Query, 
At the last step it's like this the type is text and all looks fine. 

However, after importing it into Power BI, it's still type text, but all values has gotten a .0 at the end, causing joins to other tables to fail. 

[Anonymous]

Hi @KriZo ,

Is the Enable load option turned on for this table?

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

Hi @KriZo 

Can you please supply your PBIX file so I can check it.  Or the original data - at least a sample of it.

Phil