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: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

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