Forum Discussion
Dynamic RLS using Rest API
Yes. You only have approaches but not exacly the API request as you wanted. We should stay tuned on the updates becuase the idea says "complete". It might be released soon.
Regards
Hi, thanks for the response and your suggestions.
The main transaction table has a column (with User IDs) for applying the filter logic while defining roles. And if the ID of the logged-in user matches it then, that specific data is visible to the logged-in user. I am able to achieve that step.
My major concern is if I "build a web app and control my own custom login, then I can decide in the app which RLS role to use for each user"(as you mentioned), there is the API called by passing an Effective Identity. Is it going to permanently add the user to that role? By that I mean, if the same user logs into Power BI service, that user will be able to see the data as per the assigned role? And afterward also?
An idea regarding the same thing is mentioned on this Microsoft Idea page and there is an admin reply to it saying it was done too. Is it the same Effective Identity method ?
I'm surprised about the idea in "Complete" state because it's not there in the API doc. You can check the comments below they are asking for it. Maybe it will be released soon.
Regarding your questions. When you build a custom app with custom login, users are control by you. That means they can use any account to login (of course it should help your rls table). I mean they don't need a Power Bi license, they are using a custom app and not Power Bi Service. In case they have access and get in Power Bi Service they should see anything because you haven't shared anything with them. Don't worry about that scenario.
If you can't develop the app there are already companies with apps like that. The company I work for has one 😛
I hope that helps,
Exactly me too. And it was completed in March 2022. Yeah, I checked that one of the users pretty much recently commented and asked about it. I thought maybe the person who commented just couldn't find the API 😂
Yeah, I do know that the users accessing the App don't need a Power BI license or an account of Power BI. I wanted to check for such a user who also has access to the dashboard on the service but hasn't been assigned the role yet. So that, I can test whether this API call causes a permanent update or is it on the fly happening for that API call only.
Thanks for the offer😀 The company I work for also develops them 😬
Ok then, to conclude we both agree that there hasn't been any such API provided by the Power BI REST APIs catalog that fulfills this requirement (as of 28th April 2022). Right?Yes. You only have approaches but not exacly the API request as you wanted. We should stay tuned on the updates becuase the idea says "complete". It might be released soon.
Regards
Yup. Right. Thanks for confirming and the help!