Forum Discussion
Programmatically grant user permission to a dataset
Hi, There are Power BI reports in my organization. Currently for the reports we grant access to users by going into The Wokspace, and selecting the datsets. From there we select security and add the AD user.
Is there a way that I can programmatically do this through the Power BI API ? So that can add users to the selected datasheet by passing the relevant AD user information.
If so, what approach should i take? I have currently created an "app registration" in Azure. I also had a look at the sample code at PowerBI-Developer-Samples . In this sample what confuses me is the resourceUrl which is passed at the code line
var authenticationResult = await authenticationContext.AcquireTokenAsync(ResourceUrl, ClientId, credential);
What should the resource link be? Is it the app registration's url? Azure seem to create a random url for it such as https://MycompanysDomain.com/80311e9d-c75f-4692-a513-ab36e55ba3ab which is not a valid URL
Please advise me on this. I am a complete newbie for this
Hi Shaamil,
I'm afraid there isn't such a API for now. I would suggest you vote up this idea or create a new one. Please refer to the REST APIs of Power BI: rest/api/power-bi/datasets.
Best Regards,
Dale
I upvoted the idea to create a new one. Also I checked out on the Power BI REST API. Although there is a REST method to add user to group, it only adds users to the workspace as members and not to RLS groups. [Reference: https://docs.microsoft.com/en-us/rest/api/power-bi/groups/addgroupuser] . So it seems there is no support from the Power BI REST API as well. Thanks Dale for replying for my post !
we would need this API for the exactly same use case. it would be great if Microsoft could provide it.
Has anyone got a working version of the programmatical manipulation of RLS in Power BI? It will be a big help if any lead is shown.
