Forum Discussion

sperry19's avatar
sperry19
New Member
3 years ago
Solved

Table.TransformColumns issue

Hi All,   I'm trying to fix up a report that stopped working for whatever reason, I do not have much experience with power query and am stuck. The problem is I get the error below when trying to tr...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi sperry19 ,

     

    Try to split the conversion into two steps.

        #"Changed Type" = Table.TransformColumnTypes(CMSales,{{"CREATED_DATE", type datetime}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type",{{"CREATED_DATE", type date}})

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Try using Date.From instead of DateTime.Date.

 

--Nate

sperry19's avatar
sperry19
New Member
3 years ago

Hey Thanks for the suggestion. Unfortunatly this did not work. the original data type is datetime2(7) in the database. Should I be using some function to trim the last digits so it is returned as YYYY-MM-DD hh:mm:ss?