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
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 differences
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