Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Prasanjeet
Microsoft Employee
Microsoft Employee

Using Active Directory authentication in PowerBI gateway

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.

1 ACCEPTED SOLUTION
Jayendran
Solution Sage
Solution Sage

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.

11

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.

 

22

 

33

View solution in original post

2 REPLIES 2
Jayendran
Solution Sage
Solution Sage

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.

11

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.

 

22

 

33

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?

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.