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!  
Connection SQL Server
  • 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

HarderT's avatar
HarderT
Helper II
3 years ago

Hi v-yueyunzh-msft ,

 

probably I found the problem. 

 

The Problem is that our SQL Server is an On-Premise Server not a Cloud-Server.

 

Is that correct?

 

Best regards,

Tim

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi , HarderT 

    If the sql server in On-Premise, in my understand , you must need to use the gateway to create a data source credential .

    You can try to search if the Existing connection has the configuration for your data source.

     

     

    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