I have worked with Power Query in Power BI before and I know that you can wrangle data using Power Query in Data Factory, but why would you want to use one over the other? Are there any functional differences? I haven't been able to find any comparison documentation after several searches. What would be a good use case for using one over the other? Any insight or references to comparison documentation would be appreciated.
why would you want to use the Data Factory version instead of the Power BI version
Power Query in ADF is translated to Spark and run on on-demand Spark clusters, so it's potentially much more scalable. However it doesn't support all of the Power Query functions, so it's significantly harder to use.
Read the doc here How Microsoft Power Platform dataflows and Azure Data Factory wrangling dataflows relate to each other