topic Using Active Directory authentication in PowerBI gateway in Developer

Using Active Directory authentication in PowerBI gateway

Prasanjeet — Tue, 07 Jan 2020 22:38:48 GMT

In a report I have to connect to multiple data sources - on-prem SQL DBs and Azure SQL DBs.

For on-prem SQL DBs, I have configured a gateway through which the report is accessing the data. This works.

But for connecting to Azure SQL DBs, we use Active Directory authentication.

How do I setup gateway to connect to Azure SQL with AD authentication? Only options while creating data source in gateway is 'Windows' and 'Basic', which are not working for this scenario.

Import data is configured in report.

Re: Using Active Directory authentication in PowerBI gateway

Jayendran — Wed, 08 Jan 2020 14:35:51 GMT

Hi @Prasanjeet ,

You don't need a gateway for Azure SQL DB source.

The flow is

1. Only add your onprem sql in the gateway, don't add the azure sql db as the source in the gateway. Click apply in gateway connection.

2. After that go to Data source credentials (you can see that your on-premises gateway will say admin has granted access, credentials not required) but for the other azure sql you can click edit credentails then using OAuth , sign in using your AAD autentication.

Re: Using Active Directory authentication in PowerBI gateway

IMett — Thu, 02 Apr 2020 09:39:25 GMT

Hi everyone,

we have the same problem, but the solution doesn't work like that for us unfortunately.

See this topic: https://community.powerbi.com/t5/Service/Refresh-Power-BI-Reports-with-data-in-a-managed-instance-access/m-p/965689#M89801

Is the only difference that we are using a managed instance instead auf Azure SQL DB, or is there some other trick that we might consider?