Forum Discussion
Snowflake Data Masking implementation in Power BI
I can assume if one is connecting from PBI Desktop > SF that it will use the masking policies for the credentials used to connect to it?
However I guess simplifying the question is that I am a developer and i can see X, but once i publish i may have end users who can see X, Y & Z? Can the masking follow into PBI so different users see different things?
Has anyone had any luck?
Facing the same issue too. I have use Power Bi to perform a scheduled query to snowflake where the data is cached. The query uses the Sys Admin role, and thus all data returned to power bi is unmasked. Now I would like to allow certain users with privilleges to view unmasked data and some to view the data as masked.
I have enabled sso in snowflake and i believe that it should be able to inherit the column masking properties to mask the data in power bi. So far, I am not able to make this happen. Is there any way to overcome this?