Forum Discussion
Snowflake row and column permissions
When creating a report using Snowflake data, is it possible to have the Snowflake row and column permissions be reflected in Power BI?
In other words, when viewing a report, can each person only see the same range of permissions as the Snowflake rows and columns?
Did you specify the text value for the Role name, and did you implement these roles via RLS?
I don't think you can transfer the OLS rules, though. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41
3 Replies
- lbendlin
Super User
Looks like the Snowflake connector does have these options. What have you tried and where are you stuck?
- AnonymousNot applicable
I connect the data when I create the dashboard, but after sharing, I want to make sure that the row and column level controls in Snowflake are reflected in Power BI for each user with an SSO login.
- lbendlin
Super User
Did you specify the text value for the Role name, and did you implement these roles via RLS?
I don't think you can transfer the OLS rules, though. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41