Microsoft Fabrics - Service Principal Authentication
Steps to be followed to create target DSN using Service Principal Authentication method:
- Login to Azure Portal
- Register Azure App --> Go to App registration
- Click on plus button create New Registration
- Provide the Application name and click on Register
- Registration is done successfully.
- Create Client Secret
- In the Registered App
- Go to Certificates & Secrets
Click on Client Secret and generate new client secret (The value id is displayed only once make sure to copy it)
- Assign RBAC (Role Based Access Control) Roles
- In Fabric Capacity, Go to Access Control (IAM)
- Assign the registered app as Contributor role and add it as Service principal
- Login to Microsoft Fabrics Portal
- Add Service principal as Admin in Fabrics Workspace
- Go to Manage access in Fabrics Workspace
Add the Service principal as Admin
ODBC Connection:
Install ODBC Driver for SQL Server and configure the DSN
- Add Server
- Select Azure Service Principal Authentication
- Add Client ID as Login ID
- Value ID as Password
- Test the connection
Successfully connected to Fabrics Workspace using Service Principal Authentication.