RLS not working with CUSTOMDATA() in App Owns Data semantic model

[BalaGrandhi]

I have a semantic model on which RLS is working with Username() when I use power BI embedding functionality. Now I want to consume that semantic model in our other application using C# libraries like TOM, ADOMD.net and I want to filter out the data using RLS. For that I am passing in Customdata() in connection string and I updated semantic model as well to use the same Customdata() in RLS to filter data.

In my code I see Customdata() is passing fine in connectivity to semantic model but when I try to retrieve records of the table using DAX( EVALUATE TOPN({10},TableName) expression I am not getting the filtered records as per RLS. I am getting the entire table data.

string connectStringUser = $"DataSource={workspaceConnection};User ID={userId};Password={password};CustomData={username};";

AdomdConnection advwrksConnection = new AdomdConnection(connectStringUser);

advwrksConnection.Open();

AdomdCommand cmd2 = new AdomdCommand("EVALUATE TOPN({500},TableName)", advwrksConnection);

DataTable results = new DataTable();
AdomdDataAdapter adaptor = new AdomdDataAdapter(cmd2);
adaptor.Fill(results);

 Since this is app owns data, the username and password is of service account.

[Anonymous]

Hi @BalaGrandhi ,

Have you solved your problem yet? If so, you can mark the correct answer as solution.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @BalaGrandhi ,

You can follow this step:

   1.Log the value you’re passing in the connection string to ensure it’s correct.Verify that the Customdata is being correctly interpreted by the semantic model.

   2.Confirm that the RLS rules are correctly applied to the relevant tables.

   3.Since this is an “app owns data” scenario, ensure that the service account (used for the connection) has the necessary permissions to access the data and apply RLS.

Below is the link will help you:

Connection string properties (Analysis Services) | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.