Forum Discussion

jaryszek's avatar
jaryszek
Super User
1 year ago
Solved

Update programatically dataset security roles

Hi Guys,

I discovered that there is still not REST APIs for updating RLS roles for specific datasets. 
But I found that through XMLA endpoint it is possible.

I am using REST Client with Visual Studio Code to get to XMLA Endpointand need to execute command like here:

GET https://powerbi://api.powerbi.com/v2.0/myorg/PowerBIReports({{datasetId}})/DataModelRoles
Authorization: Bearer {{$aadV2Token appOnly}}

 

it is working for usual rest apis like this one using service principal:

GET https://api.powerbi.com/v1.0/myorg/groups
Authorization: Bearer {{bearerToken}}

 

Why this is not working? How to get into this roles using rest client in visual code? Any alternative? 

Best Wishes,
Jacek

2 Replies

  • Hi There is a confusion here. This is the Power Bi Service forum but the question is showing a API Rest from PowerBi Report Server.

    In case you are asking for Report Server, then the Base URL is not that one. The base URL is:

    [ Base URL: localhost/reports/api/v2.0 ]

    https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0#/PowerBIReports/GetPowerBIReportDataModelRoles

    On the other hand if you are talking about the cloud and PowerBi Service then there is no request for RLS at all. Here you can find the requests available: https://learn.microsoft.com/en-us/rest/api/power-bi/

    I hope that helps,

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi jaryszek,


    Thanks ibarrau for Addressing the issue.

     

    we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
    If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

     

    Regards,
    Vinay Pabbu