Connect to Fabric Datawarehouse using a jdbc driver and service principal

[DaphneFabric]

Hello,

I need to connect to a Fabric Datawarehouse using a service principal to get data from this Fabric Warehouse, and send it to another destination.

Currently I am not able to find complete documentation. Is it possible to have more informations? The set-up of the workspace (Service Principal and security group) is ok.

[Anonymous · Accepted solution]

HI @DaphneFabric,

For using jdbc driver, you can refer to the following document jdbc part if it suitable for your requirement.

Connectivity to data warehousing - Connect using JDBC - Microsoft Fabric | Microsoft Learn

If you want to enable Service Principal, 2 settings in the Fabric / Power BI Admin Portal need to be enabled for this feature to work. Both can be found in the Tenant settings section. Please refer to:

Automate Power BI Premium workspace and semantic model tasks with service principals - Power BI | Mi...

If you are a newbie and you have doubts about how to register and create the service principal in azure. Please refer to:

Register a Microsoft Entra app and create a service principal - Microsoft identity platform | Micros...

Regards,

Xiaoxin Sheng