How do i connect PowerBI to SQL server

[pme94]

In my Autotask database I notice the following setting:

SQL Server-compatible Server Name (BETA): acme-autotask.database.invantive.com

I have tried to set up a Power BI SQL Server database connection using that server and my credentials (using basic authentication) but am getting a ‘Connection could not be created’ error.

[forums]

Please make sure to follow the instructions as described on:

SQL Server-compatible link for Invantive UniversalSQL databases

Go to Dutch version In the “Databases” screen on Invantive Cloud, three links are now visible for connecting to a cloud database: [image] The first two links are for use with Power BI, Qlik, and Tableau. The third and new link is the name to use when connecting based on the SQL Server network protocol. In the example above, that is: acme-exact-online.database.invantive.com Login from SQL Server-programs When logging in via SQL Server, enter this name in the “Server name” field, as shown in…

In case the problem persists: please describe the exact steps executed with anonymized screenshots.

[forums]

This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a solution.

Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.