Hvordan kobler jeg PowerBI til 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]

Dette spørsmålet ble automatisk lukket etter minst 1 uke med inaktivitet etter at en mulig løsning ble gitt. Det siste svaret som ble gitt, er merket som en løsning.

Vennligst still et nytt spørsmål i et eget emne hvis problemet oppstår igjen. Vennligst inkluder en lenke til dette emnet i det nye spørsmålet ved å lime inn URL-en i teksten.