Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered
I have a problem when I want to create an ADF dataflow with a SQL Server database as source or destination with a self-hosted integration runtime. Has anyone ever had this problem? How can I solve it?
Thank you
Solved! Go to Solution.
Assuming you are speaking about azure data factory and not fabric data pipeline, dataflow within ADF doesn't support any source using self hosted ir.
You need to use copy activity and copy data into blob or any source supported by dataflow as an intermittent layer
Hi @Mickael_Ro ,
As NandanHegde said, I likewise think this falls under the Azure Data Factory category.
You can find the solution to the problem in the Azure Data Factory related documentation.
I think you can check this official documentation for more information:
Troubleshoot self-hosted integration runtime - Azure Data Factory & Azure Synapse | Microsoft Learn
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Mickael_Ro ,
As NandanHegde said, I likewise think this falls under the Azure Data Factory category.
You can find the solution to the problem in the Azure Data Factory related documentation.
I think you can check this official documentation for more information:
Troubleshoot self-hosted integration runtime - Azure Data Factory & Azure Synapse | Microsoft Learn
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Assuming you are speaking about azure data factory and not fabric data pipeline, dataflow within ADF doesn't support any source using self hosted ir.
You need to use copy activity and copy data into blob or any source supported by dataflow as an intermittent layer
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
4 | |
3 | |
1 | |
1 | |
1 |