How do i connect PowerBI to SQL server

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.

Please make sure to follow the instructions as described on:

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