Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
We have a tabular model in our organization. i added roles on the cube level in order to mange the cube permissions for users that connect to the cube using excel.
Recently we started to enable access to the cube from power bi in order for users to be able to bulit reports and dasboards based on the cube. The connection from power bi to the cube is live connection. I also installed the on premise gateway, defined the cube data source and added the relevant users.
As far as i understand, in order for a user to connect to the cube from power bi he need to have permissions in the cube roles and need to be in the gateway users list.
What i don't understand is the behaviour in case that a user that have access to the cube (both role and gateway) builds and shares a dashboard with a user that has access to the cube at the role level but is not defined in the gateway, that user can still access the data in the dashboard. i would expect that if the user id not defined in the gateway he won't be able to access the dashboard.
Is this the expected behaviour or there is somthing wrong in my implementations?
Thanks!
Solved! Go to Solution.
@udian Adding a user to the gateway source does not effect the "read" of users who have access to the model. The only time a user is required to be on the gateway is when they need to publish a report to Power BI and connect to that gateway. Having them as a user allows them to see the gateway and use it for reports.
To say it differently. The permissions you've granted on the model will automatically work with the RLS setup when you share to a group of users that also have access to read the model. There is no need for additional configuration of those users in Power BI.
@udian Adding a user to the gateway source does not effect the "read" of users who have access to the model. The only time a user is required to be on the gateway is when they need to publish a report to Power BI and connect to that gateway. Having them as a user allows them to see the gateway and use it for reports.
To say it differently. The permissions you've granted on the model will automatically work with the RLS setup when you share to a group of users that also have access to read the model. There is no need for additional configuration of those users in Power BI.
Thank you for clarifying! Now it makes much more sense 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.