The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Solved! Go to Solution.
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
Looks like the Snowflake connector does have these options. What have you tried and where are you stuck?
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.
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