Forum Discussion
Snowflake data masking policy implementation to Power BI
Hi sowjanyapola
The data masking policies applied in Snowflake are not reflected in Power BI reports unless the semantic model is refreshed with the credentials of the user viewing the report.
This situation is typically caused by the way Power BI caches data and handles DirectQuery connections.
Instead of relying solely on Snowflake's data masking policies, you can implement row-level security (RLS) in Power BI. RLS allows you to control data access based on the user accessing the report.
Roles and rules can be defined in Power BI Desktop to filter data based on user identification.
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Thank you for your response! I know we can do it by RLS but was checking to see if anyone could directly implement the masking policies in Snowflake.