RLS with dataset import

[DavideBono97]

Hi

I have a report linked to a dataset via import schema

The dataset has RLS

I'm trying to embed this report like this 

var tokenRequest = new GenerateTokenRequestV2(reports: new List<GenerateTokenRequestV2Report>() { new GenerateTokenRequestV2Report(report.Item1) },
datasets: v2DatasetID.Select(datasetId => new GenerateTokenRequestV2Dataset(datasetId.ToString())).ToList(),
identities: v2rls,
targetWorkspaces: v2WsID
);

// Generate Embed token
var getToken = client.EmbedToken.GenerateToken(tokenRequest);

 My config client side is : 

var config = {
                    type: pbiType,
                    tokenType: pbiModels.TokenType.Embed,
   


                 //theme: { themeJson: getCurrentTheme() },
                    accessToken: options.TOKEN,
                    datasetBinding: {
                        datasetId: options.DATASETID,
                    },
                    embedUrl: options.EMBEDURL,
                    id: options.IDREPORT,
                    layoutType: models.LayoutType.Custom,
                    customLayout: {
                        displayOption: models.DisplayOption.FitToPage
                    },
                    permissions: pbiModels.Permissions.All,
                    viewMode: pbiModels.ViewMode.View,
                    settings: { 
                        panes: {
                            filters: {
                                visible: false
                            },
                            pageNavigation: {
                                visible: false
                            }
                        }
                    },
                };

Embed url generate is : https://app.powerbi.com/reportEmbed?reportId=9791f758-966c-4910-b394-3504eb9d9b9f&groupId=911bc871-5...

I received this error after one minute of loading :

PowerBI service client received error HTTP response. HttpStatus: 503. PowerBIErrorCode: OpenConnectionErrorOpenConnectionError: Failed to open the MSOLAP connection.

I tried then without RLS and everything works

Also a report linked to a dataset via DirectQuery with RLS also works

What can I do for dataset import with RLS ?

Thanks in advance

[Anonymous]

Hi @DavideBono97 ,

Hi, the issue was related to RLS. There was a rogue space in the code, specifically where we defined the Role. Hopefully this is helpful to someone in the future.

Solved: Re: Failed to open the MSOLAP connection. - PowerB... - Microsoft Power BI Community

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DavideBono97]

Hello
Could you please detail the problem?
Do you mean on the security of the dataset or what I pass as RLS to get a token on the server code?

Thanks