I have created a RLS using "username()". Data is filtered correctly when I use "View as Roles" in Power BI desktop. But when I publish to Service and check using "Test as Role" in service, Repor does not show any data.
Also users are not able to see data even when I don't add anyone to security filter.
Thanks in advance for help.
Solved! Go to Solution.
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, could you share the creenshots for your RLS set under Security in Power BI Service?