Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Team, can we integrate CRM Dataverse environment with the Fabric workspace using managed identities in Azure?
Or is there any secure way for integration other than using a user account?
If so, can somone please share the guide.
Thank you.
Solved! Go to Solution.
Hello @DanialAnwaar
Here’s how you can integrate CRM Dataverse with Microsoft Fabric using managed identities:
1. Azure Managed Identity
• Create a user-assigned identity in Azure.
• Add it as an Application User in Dataverse with appropriate roles (e.g., System Admin).
• Use the identity’s Client ID in Fabric pipelines for authentication.
2. Fabric Workspace Identity
• Enable Workspace Identity in Fabric settings (auto-creates an Azure AD service principal).
• Add the identity’s Object ID to Dataverse as an Application User.
• Select Workspace Identity in Fabric pipelines for credential-free access
if this is helpful please accept the answer
Hi @DanialAnwaar,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" and give a 'Kudos' so other members can easily find it.
Thank you,
Pavan.
Hi @DanialAnwaar,
I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.
Please continue using Microsoft community forum.
Thank you,
Pavan.
Hi @DanialAnwaar,
Thank you for reaching out in Microsoft Community Forum.
Thank you @nilendraFabric for the helpful response.
As suggested by nilendraFabric, I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.
Please continue using Microsoft community forum.
Regards,
Pavan.
Hello @DanialAnwaar
Here’s how you can integrate CRM Dataverse with Microsoft Fabric using managed identities:
1. Azure Managed Identity
• Create a user-assigned identity in Azure.
• Add it as an Application User in Dataverse with appropriate roles (e.g., System Admin).
• Use the identity’s Client ID in Fabric pipelines for authentication.
2. Fabric Workspace Identity
• Enable Workspace Identity in Fabric settings (auto-creates an Azure AD service principal).
• Add the identity’s Object ID to Dataverse as an Application User.
• Select Workspace Identity in Fabric pipelines for credential-free access
if this is helpful please accept the answer
User | Count |
---|---|
33 | |
13 | |
9 | |
9 | |
5 |