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

[Idrissshatila]

@anshkapoor143 ,

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