Unable to see data after applying row level security in Power BI service

[anshkapoor143]

Hi, after bulit the row level security unbale to see the data getting below mentioned error. even while testing in Power Bi desktop row level security is working fine.

An error was encountered during the evaluation of the row level security expression defined on table 'Test Data'. Error message: Function 'CONTAINSROW' does not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.

[Idrissshatila]

Hello @anshkapoor143 ,

the issue is clear, you're comparing a text with an integer, so go see where is the fields you're comparing in the Dax, and check the type of each and make them match.

[anshkapoor143]

Sure I will, but Row level security is working fine in power Bi desktop, they show what we need and also when we published the PBIX in workspace and apply the Row level security and test its working fine too but when I give access to other user who is viewer they are getting this error.

[Idrissshatila]

@anshkapoor143 ,

you need to assign these users to the row level in the service.

check this video from minute 2:53 to see how

https://www.youtube.com/watch?v=3jQiWHWZrNM&t=173s

[anshkapoor143]

I already did that and test as well

[gvincent]

I got same error, ... In Power BI desktop select many roles... you'll reproduce the error... even if each role, when tested individually, are ok. So your user have most likely many roles... 

I looked at the table in the message, .. everything seems fine, no error, no calculated columns with error / CONTAINS function...

... so I looked at the Measures that migh be using this table... none seemed wrong, and none were using a contains function...

... was a bit discouraged... I deleted the rules for 2 roles on this table... just to see if any impact...

... still the error...

... removed it on all roles ... so no more RLS on this table ... -> Error &?& there....

[gvincent]

... and then,.... I though of looking at the relations between this table in the message... and other table... and there was one, with a link comparing a  text vs an int value... these were all ids... so all numbers, and I guess somehow in all the other contexts, PowerBI was doing the conversion automatically... mystery solved !

[Idrissshatila]

@anshkapoor143 ,

then they should view the report, if there's an error please show us the error.