Forum Discussion
Dataverse Roles necessary for Fabric Shortcut
Luigia-Costabil
Based on Microsoft documentation and implementation experience, Dataverse Shortcuts accessing the Dataverse Managed Lake typically require the user or Service Principal (Application User) to have System Administrator privileges not less than that.
While Service Principals are supported for authentication, the Managed Lake does not appear to fully honor the standard Dataverse table-level security model. As a result, a custom read-only role with access to specific tables may not be enough.
If least privilege access is mandatory, Link to Fabric is generally the preferred approach, as access can be controlled within Fabric after the data is replicated to OneLake( unified storage).
I will also be interested to hear if anyone has successfully implemented Dataverse Shortcuts using a Service Principal with a custom security role instead of System Administrator.
If this helps, ✓ Mark as Kudos | Help Others
Luigia-Costabil
Based on Microsoft documentation and implementation experience, Dataverse Shortcuts accessing the Dataverse Managed Lake typically require the user or Service Principal (Application User) to have System Administrator privileges not less than that.
While Service Principals are supported for authentication, the Managed Lake does not appear to fully honor the standard Dataverse table-level security model. As a result, a custom read-only role with access to specific tables may not be enough.
If least privilege access is mandatory, Link to Fabric is generally the preferred approach, as access can be controlled within Fabric after the data is replicated to OneLake( unified storage).
I will also be interested to hear if anyone has successfully implemented Dataverse Shortcuts using a Service Principal with a custom security role instead of System Administrator.
If this helps, ✓ Mark as Kudos | Help Others
We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.
Hi Luigia-Costabil
Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.
