Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
Solved! Go to 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
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-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?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
6 | |
2 | |
2 | |
2 |
User | Count |
---|---|
4 | |
4 | |
4 | |
4 | |
4 |