Forum Discussion

Dua's avatar
Dua
Regular Visitor
1 year ago
Solved

when trying to set a gateway connection from sql server to powerbi,there appears error message.

when trying to set a gateway connection from sql server to powerbi,there appears error message.Help me to fix this?

Need Help
Show and Tell
Tips and Tricks
  • Dua's avatar
    Dua
    1 year ago

    Hi,

    Thanks to all who replied,
    I just realized i was using Powerbi free account,So i can use only Personal gateway.
    And On premises gateway will work under pro/embd license.

7 Replies

  • Dua's avatar
    Dua
    Regular Visitor
    1 year ago

    Hi,

    Thanks to all who replied,
    I just realized i was using Powerbi free account,So i can use only Personal gateway.
    And On premises gateway will work under pro/embd license.

    • v-menakakota's avatar
      v-menakakota
      Community Support
      1 year ago

      Hi Dua ,

      We appreciate your efforts and are pleased to hear that your issue was resolved. Please mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.

      Regards,
      Menaka.

    • v-menakakota's avatar
      v-menakakota
      Community Support
      1 year ago

      Hi Dua ,

      We appreciate your efforts and are pleased to hear that your issue was resolved. Please mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.

      Regards,
      Menaka.

      • v-menakakota's avatar
        v-menakakota
        Community Support
        1 year ago

        Hi Dua ,

        May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

        Thank you.

  • ibarrau's avatar
    ibarrau
    Super User
    1 year ago

    Hi. The message is saying that the values you are entering for Server or Database are incorrect. Are you sure the server name is just "DJ" and nothing else?

    You can connect with SQL Management Studio or other dbms to check the names you are using for server and database.

    I hope that helps,

  • v-menakakota's avatar
    v-menakakota
    Community Support
    1 year ago

    Hi Dua ,

    Thank you for reaching out to us on the Microsoft Fabric Community Forum.

    Here are few steps to may resolve the issue.

    The error suggests that the .NET Framework Data Provider might not be installed. Verify that the required version of the .NET Framework is installed on the machine running the gateway.
    Make sure the connection string is correctly formatted.Double-check that the correct server and database names are being used.
    Confirm that the on-premises data gateway is installed and configured properly. Make sure the account used to connect has the necessary permissions to access the SQL Server.

    If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

    Regards,
    Menaka

     
     
     
  • Wikkleyn_81's avatar
    Wikkleyn_81
    Super User
    1 year ago

    Hi Dua As ibarrau mentioned, try connecting to the sql server with SSMS to make sure it works. Also try using the full server name to connect to the sql server.