Need full features of Power Query in Data Factory.

Systematix Developers 0 Reputation points
2023-01-24T07:19:32.7333333+00:00

This is very important feature we should integrate in ADF because there is very less supported function in Power Query for ADF. please integrate full featured support in Power Query in ADF.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator
    2023-02-01T21:07:22.69+00:00

    Hi Systematix Developers,

    Thank you for using Microsoft Q&A forum and sharing your feedback.

    Agree that currently not all Power Query M functions/features are supported for data wrangling in ADF despite being available during authoring.

    For list of supported functions other limitations in ADF Power query, please refer to this document: Transformation functions in Power Query for data wrangling

    User's image

    To explore the difference between Power Query data flows and ADF wrangling data flows please refer to this document: How Microsoft Power Platform dataflows and Azure Data Factory wrangling dataflows relate to each other and their differencesUser's image

    As your feedback on this post seems to more of feature request, I recommend logging a feature request in ADF IDEAS forum here: ADF IDEAS forum

    All the feedback shared in this forum are actively monitored and reviewed by ADF product team.

    Please do share the feedback link once it is posted so that we can share it with internal team to further review it. Other community members reading this thread can up-vote and comment on your feature request feedback which would help increase the priority of the feedback.

    Hope this info helps.

    Thank you

    0 comments No 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.