topic Re: PowerBI Gateway connection to Azure SQL in Report Server

PowerBI Gateway connection to Azure SQL

DDavies1991 — Mon, 07 Sep 2020 15:44:26 GMT

We are currently having issues connecting our PowerBI gateway to an Azure SQL Datasource.

Our current setup is a PowerBI Gateway configured for SSO with Kerberos constrained delegation.

For the datasource connection we have the authentication type as basic however under advanced settings we have the following setting checked "Use SSO via Kerberos and DirectQuery And Import Queries.

My thought are that Kerberos isnt support for Azure SQL so this is what is causing the issue. If anyone has any thoughts or has a statment from MS that would be really helpful

Re: PowerBI Gateway connection to Azure SQL

Greg_Deckler — Mon, 07 Sep 2020 17:13:20 GMT

DDavies1991 It does support Kerberos but you have to use Azure Active Directory authentication.

Re: PowerBI Gateway connection to Azure SQL

DDavies1991 — Tue, 08 Sep 2020 11:11:33 GMT

We have set the SQL Server for AD Authentication however we are still getting the same error with that SSO checkbox enabled 😞