Row Level Security doesn't work after data refresh

[Anonymous]

Hello,

We have a report that uses RLS with multiple roles. After data is refreshed (manual or automatic), users cannot see any data. We then refresh data in Desktop and then publish to Service, and it works until the next auto refresh.

Anyone experienced this strange problem, and know the solution?

Regards, Vidyadutt

[Anonymous · Accepted solution]

Thank you all for your comments. We have finally found what was going on.

The data was refreshed, but we were getting empty values in the date column and that's why we couldn't see any data as it fails the relation with calendar dimension. The values coming from database were "datetime" and in Power BI, we changed the type to date in transformation. We removed this step and re-published the report to service, and bingo! I have no idea why the change in type would make all the values in the date column blank...

Thanks again @Mariusz and @Icey for the pointers.

Regards, Vidyadutt

[Icey]

Hi @Anonymous ,

Was the data source refreshed successfully? Can you see all data after refreshing?

Best Regards,

Icey

[Anonymous]

Hi @Icey,

That was a good tip. I checked the report and I can't see any data after refresh. I have found a few threads on this topic, and will check if any of those helps.

Thanks for the tip.

Regards,
Vidyadutt

[Icey]

Hi @Anonymous ,

What's the data source?

Do you use a gateway for refreshing?

Is there any error?

Best Regards,

Icey

[Mariusz]

Hi @Anonymous 

See if this post can help.

https://community.powerbi.com/t5/Desktop/Row-Level-Security-not-working/m-p/497797

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Thanks @Mariusz. I had seen this post, but it doesn't help. The problem we have is different.

Regards, Vidyadutt