Forum Discussion

HarderT's avatar
HarderT
Helper II
3 years ago
Solved

Connection SQL Server in Fabric

Hi everyone,   I have a question/problem.   Why can i connect my SQL Server in Fabric within a dataflow but not in a pipeline?   Thanks for help!  
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , HarderT 

    Thanks for your quick response and sorry for my delay response!

    I create a on-premise sql server and  install a gateway to test in my side .And i found we can not select a gateway in pipeline now.

    As searched ,  the Self-hosted IR / Data Gateway that's needed for Fabric pipelines to connect to on-prem data sources is not available in yet.

    Please reference the official confirmation at:
    Differences between Data Factory in Fabric and Azure - Microsoft Fabric | Microsoft Learn

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly