Forum Discussion
getting started with data factory
no, that looks like all the rest of the tutorials where a standard off the shelf data source is used. As i stated i want to plug in a scripted data source (either python or power query generated in pbi from what was originally python) . from what i saw in the data factory advertising, power query is supposed to be compatible.
Generally speaking, you should be able to take your Power Query M code generated in Power BI Desktop, or Excel, or other Power Query integrations and create a Dataflow Gen2 in Data Factory in Fabric with it.
There are a number of exceptions to the general case though:
- Some data connectors might not be supported. Refer to List of all Power Query connectors - Power Query | Microsoft Learn for more details.
- Some data transformations might not be suported. There are very few on this bucket, but particularly R & Python scripts created in Power Query within Power BI Desktop are not supported in other hosts, including Data Factory in Fabric.
Hope that helps - Per your earlier comments, if your PQ queries in Power BI Desktop are fully created in PQ (e.g. not copy-pasted Python code), you likely should be able to make those work in a Dataflow Gen2 and leverage Output Destinations currently supported: Azure SQL Databases, Fabric Lakehouse/Warehouse/KQL.