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

11 Replies

    • v-yueyunzh-msft's avatar
      v-yueyunzh-msft
      Community Support
      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

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

    Hi , HarderT 

    Based on my test and research, if you are trying to connect to SQL Server data source in your Power BI data flow gen2 workload in the Fabric platform, it can be achieved and please detailed refer to this step:

    You can first go to a Fabric workspace to create a new dataflow gen2 workload:

    And you can select the "SQL Server" button to enter your detailed SQL Server detail info and credential to establish the connection to it:

     

    You may also detailed refer to this official document link:

    Connect to data sources for dataflows - Power Query | 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

         

  • 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

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

      Hi, HarderT 

      Thank you for your reply. There is no expected launch time yet. Generally, when new features are released, they will be seen in the monthly update summary.

       

      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

  • ilseeb's avatar
    ilseeb
    Advocate I
    2 years ago

    HarderT were you able to make it work in a Pipeline? I have the same issue in which I can connect in a DataFlow but in the Pipeline I am having connection issues.