1.

Organization is owning Power BI workspace and wish to give access to members based out of managing their respective Locations. Best solution?

Answer»

This can be achieved by DYNAMIC Row Level Security(RLS) in Power BI.

Steps to be followed:

  • In Modeling menu.
  • Select Manage Roles.
  • Create & define Role name.
  • Select REQUIRED table and UserPricnicpalName() function and publish this to Power BI Service.

Once users LOG in to Power BI service with respective user id (UserPricnicpalName()) they will be able to SEE only data based on role we created.



Discussion

No Comment Found