Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Data type changes after power query

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. 

 

 

Need Help
Tips and Tricks

2 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    2 years ago

    Hi Anonymous 

     

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

     

    Phil

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

     

    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.