Facing Issue using CUSTOMDATA() DAX with on Prem Analysis server

[Anonymous]

In our model we are passing a custom data that is the Product_name.

The security table has two column Product_name and company_name so based on the Product_name the company related data gets filtered.

Once this set up is completed, we test this for Embed.

We generate a embed token and once the token is generated, we use the power bi embed app to see the output.

This is working fine when the cube is hosted on Azure Analysis Server.

Sample code to generate token: 

{ "accessLevel": "View", "groupId": "9f3e7215-3252-417f-b33b-6d4da59ac0ef", "reportId": "c8f9dee0-bce4-409c-a65c-3d6d1e5983ed", "identities": [ { "username": "hema@xxy.com", "roles": ["Head"], "customData": "xyz", "reports": [ "c8f9dee0-bce4-409c-a65c-3d6d1e5983ed"], "datasets": [ "e4c121f0-41ea-46f5-9e2e-524981b22b69" ] } ] }

But when I host it in local Analysis service, I am getting the below error while trying to generate a token:

{   "error": {     "code": "InvalidRequest",     "message": "Dataset e4c121f0-41ea-46f5-9e2e-524981b22b69 doesn't support providing CustomData in effective identity"   } }

Is this CUSTOMDATA() function applicable with on prem SSAS or only on Azure SSAS?

[Anonymous]

Hi @Anonymous ,

As described in this official documentation, the CustomData feature only works for models that lie in Azure Analysis Services, and it only works in Connect live mode. I found the following blog, hope it can help you.

Using CUSTOMDATA and On-Premises SSAS with Power BI Embedded

Best Regards

[Anonymous]

Hi Rena,

Thanks for your response.

i checked that blog but still they are using Username but i would like to pass the product name from an application, i dont have the username .

the data is dynamic and i cannot keep changing it in cube. 

Regards,

Hema