Forum Discussion
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.
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*.
For more information,you can refer to:
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.
1 Reply
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*.
For more information,you can refer to:
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.