Forum Discussion

jonharding's avatar
jonharding
Advocate II
8 years ago
Solved

Using CustomData with Azure Analysis Services

Hello,   I'm embedding reports that use a live connection to Azure Analysis Services in an 'App Owns Data' scenario.  I'd like to use the CustomData feature, as described here, to do dynamic filter...
Need Help
  • nimrod's avatar
    nimrod
    8 years ago

    Hi,

    This sentence in the documentation isn't updated, we will fix that.

    See this section in the same doc, on how to use 'CustomData'.

v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
8 years ago

Hi,

 

I think you are hitting the limits when using the RLS in Power BI Embeded for Azure Analysis Services:

"

  • Analysis Services live connections are supported for on-premises servers.
  • Azure Analysis Services live connections support filtering by roles, but not dynamic by username.

"

Looping Staff nimrod to confirm the current status for whether Custom Data filter is supported when it comes to RLS in Power BI embeded for Azure Analysis Services.

 

A thread for your reference.

 

Regards,

Michael

jonharding's avatar
jonharding
Advocate II
8 years ago

Hello,

 

I'm trying to embed all of the reports in a workspace, in an 'App Owns Data' scenario.  The reports use an on-prem SSAS model as a source, which has RLS defined in the model using roles.  My understanding from this documentation is that I should be able to pass in an EffectiveIdentity to the GenerateTokenRequest method where I specify the username, role to use and dataset id.  However, when I do this I'm getting the following error: "Creating embed token for accessing dataset xxxx-xxxx-xxxx-xxxx shouldn't have effective identity".

 

This is the code that I'm using:

var generateTokenRequestParameters = new GenerateTokenRequest("view", null, identities: new List<EffectiveIdentity> { new EffectiveIdentity(username: username, roles: new List<string> { "PBITest" }, datasets: new List<string> { report.DatasetId }) });

var tokenResponse = client.Reports.GenerateTokenInGroupAsync(groupId, report.Id, generateTokenRequestParameters).Result;

I'd really appreciate some help on finding where I've gone wrong...

 

Thanks!