Using Active Directory authentication in PowerBI gateway

[Prasanjeet]

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.

[Jayendran · Accepted solution]

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.

1

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.

2

3

[IMett]

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-ac...

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?