Forum Discussion

KasperJ90's avatar
KasperJ90
Helper III
4 years ago

Error when try to connect to datamart to SQL server database

Hi,

 

I get this error when I try to sign in to my organization account and connect to our SQL server.

Am I doing something wrong or is it a temporary error?

 

 

Need Help

8 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    Hi, KasperJ90 

    Would a similar error occur when creating a dataflow ?
    Please recheck your server name and database name and make sure there are no extra characters or any erroneous space in the path.

    You can also try use "Basic" authentication to replace 'Organizational'.

     

     

    Best Regards,
    Community Support Team _ Eason

    • KasperJ90's avatar
      KasperJ90
      Helper III
      4 years ago

      I can connect to the SQL server via Microsoft SQL Server Management Studio and Power BI desktop. Why is it not working? I need to create the data mart so I have to do it via the webbrowser.

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        4 years ago

        Hi, KasperJ90 

        I can create a datamart normally on my side to access the data source of sql server (The authentication method used by the gateway I added is ’windows‘).

        If you are sure your credentials are correct, please turn off the firewall and try again.

         

        Best Regards,
        Community Support Team _ Eason

         

         

    • KasperJ90's avatar
      KasperJ90
      Helper III
      4 years ago

      Hi v-easonf-msft ,

       

      Thanks for your reply. I get the same error when I try to do it in a dataflow as well.

      I get the error when I press "sign in" so the server I enter should not matter. I tried both in Edge and Firefox.
      I have added a Excel file from Onedrive to my datamart that worked fine. 

      Hope you can help.