Forum Discussion
Using CustomData with Azure Analysis Services
- 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'.
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
- jonharding8 years agoAdvocate II
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!
- jonharding8 years agoAdvocate II
Hello,
I'm embedding reports that use a live connection to Azure Analysis Services in an 'App Owns Data' scenario. I'd like to explore the possibility of using the CustomData feature for dynamic filtering of reports as documented here.
The problem I have is that the EffectiveIdentity object has no overload for including CustomData as described in the documentation. How do I pass CustomData in this case? Here's an example of the code I'm currently using to generate the embed token:
var generateTokenRequestParameters = new GenerateTokenRequest("view", null, identities: new List<EffectiveIdentity> { new EffectiveIdentity(username: username, roles: new List<string> { "TestRole" }, datasets: new List<string> { report.DatasetId }) }); var tokenResponse = client.Reports.GenerateTokenInGroupAsync(groupId, report.Id, generateTokenRequestParameters).Result;How should I modify this to support CustomData?
Thanks!
- nimrod8 years agoResolver II
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'.