Forum Discussion

neeraj27's avatar
neeraj27
Frequent Visitor
3 years ago

The text values are getting converted to Time format.

Hi Team,

I can see the data in text format in "Transform Data" tab but once I do close apply. My data in Power BI is getting converted to incorrect time format. Also time format columns  are having values of Text Column. Please find the attcahed images for more understanding. 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • Mahesh0016's avatar
    Mahesh0016
    Icon for Super User rankSuper User
    3 years ago

    neeraj27 Please also change type in desktop in text.
    > Desktop > go to Data view > click on column > Home Tab > Change Column Type to TEXT

    neeraj27 Thank You!!

    • neeraj27's avatar
      neeraj27
      Frequent Visitor
      3 years ago

      BS!! This is not even close to solution

  • neeraj27's avatar
    neeraj27
    Frequent Visitor
    3 years ago

    I have alraedy done that. Still the error persists