Share via

Unsupported constant null error for a power query transformation - Azure Data Factory

pmscorca 817 Reputation points
2023-04-21T06:12:29.7466667+00:00

Hi, inside a Data Factory solution, I'm trying to apply some power query transformations to a csv source file. In particular, I need to transform an invoice date field into the date type. I've tried with these input formats:

  • 2023-02-14 (yyyy-mm-dd)
  • 2023-14-02 (yyyy-dd-mm)
  • 14-02-2023 (dd-mm-yyyy)
  • 14/02/2023 (dd/mm/yyyy) but I've obtained always the error "Unsupported constant null".
    Using the Power Query inside the Power BI desktop I can change the type for the invoice date without any issues. Any suggests to me, please? Thanks
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,784 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2023-04-24T21:17:13.99+00:00

    Hello @pmscorca Thanks for the question and using MS Q&A platform. I think as work around is already documented here , not sure if you had a chance to have a look on that . User's image

    Thanks
    Himanshu
    Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues.