Fabric Monday 65: Using Service Principals with Data Warehouses

Описание: Did you know that in Microsoft Fabric you can use a workspace identity as a service principal to connect directly to your Data Warehouse?

In this walkthrough, I show how to:
🔑 Configure the workspace identity to act as a service principal
🗄️ Connect securely to a Fabric Data Warehouse through SSMS (and other tools)
⚡ Simplify authentication and improve security by avoiding user-based connections

This approach helps you set up consistent, automated, and secure connections — perfect for scenarios where you don’t want to depend on personal credentials.

Have you already tried using workspace identities as service principals in your projects? I’d love to hear how you’re applying them.


You may also be interested in the following videos:

👉 Fabric Monday 66: Creating a Service Principal owned Data Warehouse
   • Fabric Monday 66: Creating a Service Princ...  

👉 Fabric Monday 51: Using Service Accounts to Connect to Resources
   • Fabric Monday 51: Using Service Accounts t...  

👉 Fabric Monday 56: Using Workspace Identity to Authenticate Cloud Connections
   • Fabric Monday 56: Using Workspace Identity...  

Chapters

00:00 Introduction
00:10 Start
00:29 Service Principals and Data Warehouses
01:47 Creating a Workspace Identity
02:25 Creating an App Registration Secret
04:58 Configuration Warehouse permission to the workspace identity
05:43 Connecting to the Warehouse
07:38 Configuring the connection with the service principal

Let's connect
============
MMDPUG Meetup: https://www.meetup.com/MMDPUG/
MMDPUG Facebook Page : https://tinyurl.com/MMDPUGPAGE
MMDPUG Facebook Group : https://tinyurl.com/MMDPUGGROUP
LinkedIn:   / dennestorres  
Twitter:   / dennes  
What's App Group: https://tinyurl.com/MMDPUGCHAT
Email: [email protected]