unable to generate token using the datasetid for reports using effective identity

Sanjana — Wed, 04 Sep 2019 13:54:30 GMT

using (var client = new PowerBIClient(new Uri(API_URL), new TokenCredentials(accessToken, "Bearer")))
{
Report powerBiReport = await client.Reports.GetReportInGroupAsync(groupId, reportId.ToString());
#region default
var generateTokenRequestParameters = new GenerateTokenRequest("view", null, identities: new List<EffectiveIdentity> { new EffectiveIdentity(username: username, roles: roles, datasets: new List<string> { powerBiReport.DatasetId }) });
var token = await client.Reports.GenerateTokenInGroupAsync(groupId, reportId, generateTokenRequestParameters);

}

it works fine without effectiveidentity ut it fails with effective identity. Please help in identifying the parameters

Re: unable to generate token using the datasetid for reports using effective identity

Jayendran — Thu, 05 Sep 2019 05:28:11 GMT

Hi @Sanjana ,

What do you mean by fails , do you get any error ? pls share that.

Make sure that username ,roles are not having null values
Make sure your reports developed using the RLS

                    if (datasets.IsEffectiveIdentityRolesRequired == true)
                    {
                        if (!string.IsNullOrWhiteSpace(username))
                        {
                            var rls = new EffectiveIdentity { Username = username, Roles = new List<string> { roles }, Datasets = new List<string> { report.DatasetId } };

                            if (!string.IsNullOrWhiteSpace(roles))
                            {
                                var rolesList = new List<string>();
                                rolesList.AddRange(roles.Split(','));
                                rls.Roles = rolesList;
                            }
                            // Generate Embed Token with effective identities.
                            generateTokenRequestParameters = new GenerateTokenRequest(accessLevel: "view", identities: new List<EffectiveIdentity> { rls });
                        }
                       
                    }

Try the above code which having more condition for you to check

topic unable to generate token using the datasetid for reports using effective identity in Developer

unable to generate token using the datasetid for reports using effective identity

Re: unable to generate token using the datasetid for reports using effective identity