Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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