Skip to main content

Power BI

New

Ability to create own reports without edit right and disabling RLS

Vote (14) Share
Ryszard's profile image

Ryszard on 26 Jun 2017 22:04:01

Now, if one wants to create his/her own reports based on data model (dataset) prepared for a company, he/she has to have edit rights for the workspace assigned. Edit right disables Row Level Security. So, it is not possible to delegate report creation to users, who should not see all the data from given dataset.

It would be very useful if e.g. RLS would work for users with 'edit right', or if dataset would be available (e.g. as a Power BI Service) for users with 'view only right'.

Comments (6)
Ryszard's profile image Profile Picture

a45274ea c000-4244-a332-97d9f69a7a3c on 05 Jul 2020 23:30:13

RE: Ability to create own reports without edit right and disabling RLS

Seems very strange that we can't have a 'self service' tool with RLS applied. That is I can't share a subset of the organisation's data with a colleague and allow them to edit the contents of the report to suit there own needs.

Ryszard's profile image Profile Picture

235072a1 75d7-47d2-ac2a-79c5b0c4804d on 05 Jul 2020 23:28:51

RE: Ability to create own reports without edit right and disabling RLS

I'm very wondered to do not have this feature and the lower level of vote. Democratisation of BI / Self-Service BI must be joinded with data governance and RLS.

Ryszard's profile image Profile Picture

1ee806f9 5e55-4808-8b1b-8ba1ba056add on 05 Jul 2020 23:22:04

RE: Ability to create own reports without edit right and disabling RLS

Could not agree more, this functionality would be huge for our organization

Ryszard's profile image Profile Picture

00692b33 66ff-4aa4-a5fb-b25a1b47fa3f on 05 Jul 2020 22:59:32

RE: Ability to create own reports without edit right and disabling RLS

To me this is one of the most important ideas submitted and wondering why it has so few votes. Right now you either get RLS or BI Self Service, not both unless you use SSAS. Am i missing something but if you are asking enterprise clients to choose between self service and RLS they will choose Tableau or QlikSense as Jan pointed out.

Ryszard's profile image Profile Picture

aa522a3f 4c56-4601-b744-4bcaa578d784 on 05 Jul 2020 22:57:07

RE: Ability to create own reports without edit right and disabling RLS

Seems like a must have for me as well,it's called "self-service" BI after all.... Certainly sinse QlikSense does offer this functionality through section access in load scripts.

Ryszard's profile image Profile Picture

a03aba49 627f-409b-9c27-b43cee43435a on 05 Jul 2020 22:53:23

RE: Ability to create own reports without edit right and disabling RLS

RLS should work for users with 'edit right'