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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Can I allow only OAuth for connection Azure SQL ?

I want to set up a data source from the PowerBI service to Azure SQL. I want users to authenticate using integrated authentication. Is it possible to configure Azure SQL or PowerBI service to allow only OAuth authentication instead of Basic authentication at this time?
Azure SQL is allowing access from PowerBI and is integrated with Azure AD.
The goal is to limit the PowerBI tenants that can access it, so that they cannot take the data out. For example, if user X of PowerBI tenant A can refer to AzureSQL, but user X creates his own PowerBI tenant and creates a data connection to Azure SQL with Basic authentication, he can take out the data.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous ,

 

Basic authentication only requires a user’s credentials to access their account. The user’s credentials are sent from the application for *every request*.

 

oauth Azure SQL.PNG

 

For more information,you can refer to:

Securing the connection between Power BI and Azure SQL Database | Azure Blog and Updates | Microsoft Azure

Azure SQL Database with DirectQuery - Power BI | Microsoft Docs

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @Anonymous ,

 

Basic authentication only requires a user’s credentials to access their account. The user’s credentials are sent from the application for *every request*.

 

oauth Azure SQL.PNG

 

For more information,you can refer to:

Securing the connection between Power BI and Azure SQL Database | Azure Blog and Updates | Microsoft Azure

Azure SQL Database with DirectQuery - Power BI | Microsoft Docs

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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