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 ,

 

thank you for your response.

 

I know that I can connect my SQL Server via Dataflow. But I'm wondering why it doesn't work with a pipeline!?

 

 

I'm wondering because I have the option to choose a SQL Server for import data.

 

Best regards,

Tim

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

Hi, HarderT 

Thanks for your quick response!

According to your description, you want to connect to a sql server in a pipeline.

Sorry for i may misunderstand your need.Do you mean you want to use this feature in Fabric?

I test it in my side when i clcik "Copy data":

We can choose the "Sql Server " as the data source.

Or it means that your dataflow can connect to sqlserver, but the pipeline cannot connect successfully?

If so, you need to check that the SQL Server server name, credentials and gateway you entered are exactly the same.

 

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