Cards With RLS Blank in Dashboard

[danderson2692]

Hi all,

I'm running into an issue where values reported in a dashboard do not match the values in its source report for other users' accounts. In this case, I have RLS to restrict the dataset and have published it in an app. 

This first image is from the page in the report. For this user, you can see that dates and values are recorded.

When I look at a dashboard where I've pinned those same card visuals from the report, you can see that the values all appear blank. The Current Account card is a measure that returns userprincipalname(), and that does appear correctly.

I do not see this issue with my account, although from searching this forum I've seen that it's possible for the owner/admin to see different data than other users. I've configured RLS security settings applied with a distro list which includes myself and the user I'm testing with so there shouldn't be a difference in how they're applied.

Any ideas what the issue might be?

Thanks in advance.

[danderson2692]

Just found this as a potential solution (setting workspace to view-only for members). I'll test this out in the morning to see if it fixes the issue. https://stackoverflow.com/questions/50021342/row-level-security-not-working-in-power-bi-with-groups

[danderson2692]

Looks like that didn't fix the issue. Any other ideas?

[danderson2692 · Accepted solution]

I've deleted my report and the dataset, then published it again which appears to have fixed the issues. Looks like that's the easiest way to fix this problem rather than trying to fix the published version.