Forum Discussion
Issues Authenticating via Service Principal in Fabric Notebook to Connect on Semantic Model
- 11 months ago
Hello Anonymous,
Thank you for the update. We sorry the issue persists. Based on recent Microsoft documentation, service principal authentication is supported for semantic link functions, including TOM interactions via connect_semantic_model, but it requires using the updated authentication methods introduced in semantic link version 0.12.0 or later (released around September 2025). The original service_principal_authentication approach may be incompatible due to library changes, which could explain the ImportError from mismatched versions.Recommended Steps:
- Install the latest semantic link version with !pip install -U semantic-link-sempy and restart your notebook kernel.
- Switch to set_service_principal or Azure SDK TokenCredential to set credentials, then use connect_semantic_model for TOM access. For non-interactive runs, no extra config is needed if triggered by SP.
- Confirm your SP has ReadWrite permissions on the semantic model (via XMLA endpoint enabled) for modifications like creating partitions.
- Once connected via TOM, you can add partitions to tables in the model and save changes. This works on Import mode semantic models.
If the error continues after updating, it may be a version mismatch. consider pinning to 0.12.0 specifically.
For detailed guidance:
- Service Principal Support for Semantic Link (includes authentication examples and supported functions).
- Semantic Link Overview.
- Tabular Object Model (TOM) Documentation (for partition creation via TOM).
Best regards,
Ganesh Singamshetty
Hi dimitraga10_,
Thank you for reaching out to the Microsoft fabric community forum. There might be an issue with library compatibility. If there was a recent update, it could have introduced breaking changes. You can try reverting the sempy library to version 1.6.2
Check your service principal has Member or Contributor access to the workspace, Build permissions on the dataset, and Get/List secrets access in Key Vault.
Or use the stable sempy.fabric package with Fabric REST APIs for reliable SP authentication and dataset operations. See: Fabric REST API Docs.
If issue persists, consider authenticating through Microsoft Entra authentication or using the workspace identity to see if that resolves the issue.
Best regards,
Ganesh Singamshetty.