Forum Discussion
Dynamic RLS solution is not working for newly added users
Hi Anonymous,
I found the issue, manual refresh of dataset in service was failing.
There was no error in gateway integration. I removed the connection from gateway and readded, then the refresh the dataset and it started to work.
Now Joe is able to see his data as well in dynamic RLS report.
Thanks!
Hi Xiaoxin Sheng,
My problem is not adding user in role under PBI service, I can add user or groups here. And I don't mind adding the new user again and again.
My Scenario is I added a user Joe.xyz for a company XYZ in SQL dataset and company role in dataset secuirty permission page.
I refresh the dataset, now my expectation is Joe.xyz should able to view company data XYZ. But the actual is, Joe is unable to see the data of XYZ.
To fix it, I goto desktop version and refresh the data and publish it again, then it is working for Joe.
So the question is when we refresh the dataset in power bi service, why Joe is was unable to view the report data of XYZ?
Regards,
Sajna M
Hi Sajna_M,
What's wrong with joe ? Can't view records, show error or other? In addition, have you try use 'test with role' feature to test on power bi service?
BTW, I'd like to suggest you to check detail records to confirm if these records has update to power bi service dataset.
Regards,
Xiaoxin Sheng
Hi Anonymous,
I found the issue, manual refresh of dataset in service was failing.
There was no error in gateway integration. I removed the connection from gateway and readded, then the refresh the dataset and it started to work.
Now Joe is able to see his data as well in dynamic RLS report.
Thanks!