Forum Discussion

ALMalecha's avatar
ALMalecha
Frequent Visitor
1 year ago
Solved

User Security Issues with Semantic Model From Mirrored Database

We are using Fabric Mirrored Databases.   With the mirrored database, I have the SQL analytics endpoint.  In the endpoint, I've created a view.  I created a semantic model over the view, called Docu...
Fabric
Mirrored Database
  • v-prasare's avatar
    v-prasare
    1 year ago

    Hi ALMalecha,

     

    This happens because mirrored databases do not yet fully support role-based security isolation, and semantic models built on them often require pass-through authentication or viewer access at the data source level — even if the user is not expected to access the database directly.

     

    This means that users might need explicit permissions to access the mirrored data, even if they have access to the semantic model or reports built upon it: Please refer to below docs

    https://learn.microsoft.com/en-us/fabric/database/mirrored-database/azure-sql-database-limitations

     

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

     

     

     

     

v-prasare's avatar
v-prasare
Community Support
1 year ago

Hi ALMalecha,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

 

 

 

Thanks,

Prashanth Are

MS Fabric community support

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query