How do set the Row-level Security roles within the PowerBiClient SDK

[BartHuls]

All,
WithIn the PowerBiClient SDK I want to update / set  a Row-level Security roles.
The Group will then be visible in underlying screen.

Thanks in advance

[BartHuls · Accepted solution]

This cannot be done by the PowerBIClient SDK.

For now I have the following solution. It's not nice, but it works. based on the Microsoft.AnalysisServices.Tabular lib.

public async Task SetRowLevelSecurity(string groupName, string datasetId, Guid domainGroupId, string domainName, string tenantId)
    {
        _authenticationResult ??= await GetAccessToken();

        var dataSource = $"powerbi://api.powerbi.com/v1.0/{domainName}/{groupName}";

        using var server = new Server();
        server.Connect($"DataSource={dataSource};Password={_authenticationResult.AccessToken}");

        var database = server.Databases.Find(datasetId) ?? throw new NullReferenceException(_cannotFindDataSet);

        // Cast is needed otherwise the loading does not work
        var model = (Model)database.Model;
        var role = model.Roles.Find(<RoleName>);
        if (role is not null)
        {
            var memberName = $"obj:{domainGroupId}@{tenantId}";
            var member = role.Members.FirstOrDefault(m => m.Name.Contains(memberName, StringComparison.OrdinalIgnoreCase));
            if (member is not null)
            {
                return;
            }

            role.Members.Add(new ExternalModelRoleMember
            {
                MemberName = memberName,
                MemberType = RoleMemberType.Group,
                IdentityProvider = "AzureAD"
            });
            database.Model.SaveChanges();

            logger.LogInformation("Row Level Security set for {GroupId} for dataset {DataSetId}", domainGroupId, datasetId);
        }
    }

[v-csrikanth]

Hi @BartHuls 
Please do raise your new thoughts in the ideas forum and upvote it so that it will be adressed by the Microsoft internal team.

Best Regards,
Community Support Team _ C Srikanth.

[lbendlin]

Not currently available in any of the APIs. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

[BartHuls]

Is there a way to set this from the outside? how to a access a xmla endpoint

[lbendlin]

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com