Forum Discussion
Using Active Directory authentication in PowerBI gateway
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
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
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?
