Hur ansluter jag PowerBI till 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]

Den här frågan stängdes automatiskt efter minst 1 veckas inaktivitet sedan en möjlig lösning hade föreslagits. Det senaste svaret har markerats som lösning.

Om problemet uppstår igen, vänligen ställ en ny fråga i ett separat ämne. Inkludera gärna en länk till det här ämnet i den nya frågan genom att klistra in dess URL i texten.