Comment connecter PowerBI à un serveur SQL

[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]

Cette question a été automatiquement fermée après au moins 1 semaine d’inactivité suite à la proposition d’une solution possible. La dernière réponse donnée a été marquée comme solution.

Si le problème se reproduit, merci de poser une nouvelle question dans un sujet distinct. Veuillez inclure un lien vers ce sujet dans la nouvelle question en collant son URL dans le texte.