Snowflake Data Masking implementation in Power BI

[Pulendar]

Snowflake Data Masking implementation in Power BI: Has anyone implemented Snowflake data masking implementation in Power BI.

We did implement the SSO with Snowflake, about to do a POC with data masking functionality using Snowflake Policies. Has anyone implemented this? Are there any additional things to configure in Power BI other than SSO setup?

Regards,

Pulendar.

[partha_syd_bank]

HI, facing the same issue, has anybody figured out how to implement the masking policy?

When I use Power BI service, the data is always masked. 

[Shabyman2]

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?

[just_t]

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?

[pbi_Ad]

I implemented it just now. I don't know if this is what you meant. I connected power bi to snowflake and logged in using snowflake credentials for a user which was setup to unable to view full data(masked user) and it worked and then I closed that power bi window and logged in again but this time with snowflake login details for a user with full access to data and it worked.

[Pulendar]

When you publish that report to Power BI Service, 1st and 2nd Users should be able to access the report and see the data according to their access level. Like User1 should see data as **** and user2 should see the actual data from the database. like 999-100-00 etc.

[pbi_Ad]

Hi, I tried doing it. I masked data in snowflake than created a user with access to data but with masking policy applied to see if that same user connects snowflake to power bi than does the data stay masked but found out that it doesnt work. I am hoping I was wrong and maybe someone finds out a way to make it work but can't find any other documentation online to say it works. 

[v-luwang-msft]

Hi @Pulendar ,

Unfortunately, I did a search and didn't find any details about this and I doubt its feasibility in Power BI.

We hope that other experienced users will share their advice with you, and we look forward to your fen'xi when you have inspiration.

Best Regards

Lucien

[Pulendar]

Sure Lucien, thank you.

Let's keep this open until we receive any response from gurus. If not until one of us gets hands on extersize on it.

Thank you,

Pulendar