Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

jimliu

Support External SqlConnection to Fabric WareHouse/LakeHouse Using OAuth 2 Code Grant AccessToken

Submitted by on ‎04-17-2025 07:46 AM

We have a need to use OAuth 2 Code Grant AccessToken acquired from Azure AD to make external(outside Azure) SqlConnection(dotnet sql client) to Fabric LakeHouse/WareHouse to access our customers' tables.
Currently, if we do that, we got login authentication failure. We tested the same AccessToken can be used to connect to SQL Database in Fabric.

We have tested the same SqlConnection using username/password or service principle's clientId/clientSecret to connect to Fabric LakeHouse/WareHouse, they all work fine.

 

Please consider support for this authentication method for LakeHouse and WareHouse. Very much appreciated!

Status: New
Comment