Share via

powerquery i get error userquery: error unsupport constant null, while it seems to work fine

Lex de Krijger 0 Reputation points
2024-04-11T13:42:22.67+00:00

afbeelding

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Amira Bedhiafi 42,941 Reputation points MVP Volunteer Moderator
    2024-04-11T21:35:32.8+00:00

    Based on this old thread, (if you are not doing it in this way) you may need to change the type of the column directly like below :

    User's image

    I may also be a problem of your datasource if some values in the original column cannot be converted to a Date/Time format.

    Was this answer helpful?

  2. Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
    2024-04-11T21:34:39.5933333+00:00

    Hello Lex de Krijger,

    Welcome to the Microsoft Q&A forum.

    From the below documentation link, TransformColumnTypes -string to time (datetime) is unsupported in ADF

    https://learn.microsoft.com/en-us/azure/data-factory/wrangling-functionsUser's image

    As a workaround can you use Date.FromText for the datetime? Please see the below reference document.

    https://learn.microsoft.com/en-us/powerquery-m/date-functions

    I hope this helps.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.