topic Re: Using Customdata with live connection to on-prem SSAS in Developer

Using Customdata with live connection to on-prem SSAS

Anonymous — Tue, 24 Dec 2019 15:49:34 GMT

Hi All,

I'm implementing a Power BI Embedded solution having a live connection to my on-prem SSAS. I want to define roles based on my application username. I followed this blog : https://www.kasperonbi.com/using-customdata-and-ssas-with-power-bi-embedded/

The solution works fine in the service, I can see using SQL Server Profiler that the customdata has been passed. But when calling the API for the embed token, I get the following error:

Operation returned an invalid status code 'Forbidden'

I noticed while debugging that the customdata value hasn't been passed and it's always null.

I use the following to generate the token:

var generateTokenRequestParameters = new GenerateTokenRequest("View", identities: new List<EffectiveIdentity> { new EffectiveIdentity(username: currentUserName, roles: new List<string> { "RoleA" }, datasets: new List<string> { "b1ff16fc-aa63-49a3-8cb6-cad785b228f7" }) });
string embedToken =
(await pbiClient.Reports.GenerateTokenInGroupAsync(workspaceId,
report.Id,
generateTokenRequestParameters)).Token;

Can you help me troubleshoot this issue, a quick answer would be much appreciated.

Best,

Re: Using Customdata with live connection to on-prem SSAS

v-juanli-msft — Thu, 02 Jan 2020 07:07:25 GMT

Hi @Anonymous

Please refer to the following documents:

steps to begin setting up the CustomData() feature with your Power BI Embedded application.

https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security#working-with-analysis-services-live-connections

Best Regards

Maggie

Re: Using Customdata with live connection to on-prem SSAS

Anonymous — Fri, 03 Jan 2020 18:26:53 GMT

Thank you for your answer,

this is exactly what I followed. Now I'm getting another error, if I embed the report without any role it works perfectly, but once I add a role, it says "can't deploy the visual" and SQL profiler shows the following : "The cube either does not exist or has not been processed."

Has anyone faced this before ?