Forum Discussion

MahdiG's avatar
MahdiG
Frequent Visitor
4 months ago
Solved

Microsoft Fabric Data Agent and Row Level Security (RLS)

Hi everyone, I’m facing an issue with Fabric Data Agent + RLS on a Snowflake Mirrored Database and I’d like to know whether this is an expected limitation or a bug. Scenario I have a Snowflake M...
governance
  • v-achippa's avatar
    v-achippa
    4 months ago

    Hi MahdiG,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Based on your requirement, this behaviour is expected. Currently RLS works correctly when querying through the sql endpoint, but it may not fully supported when accessed via the data agent, especially for mirrored databases like Snowflake.

    If possible, please use the sql endpoint or a semantic model where RLS is required.

    If this capability is required, please raise a Microsoft support ticket so the product team can investigate further.

    Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn

     

    Thanks and regards,

    Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
4 months ago

Hi MahdiG,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Based on your requirement, this behaviour is expected. Currently RLS works correctly when querying through the sql endpoint, but it may not fully supported when accessed via the data agent, especially for mirrored databases like Snowflake.

If possible, please use the sql endpoint or a semantic model where RLS is required.

If this capability is required, please raise a Microsoft support ticket so the product team can investigate further.

Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn

 

Thanks and regards,

Anjan Kumar Chippa