topic Re: Dynamic RLS works in Power BI Desktop, but does not in Power BI Service in Report Server

Dynamic RLS works in Power BI Desktop, but does not in Power BI Service

RodrigoMachado — Mon, 29 Mar 2021 20:37:03 GMT

Hi everyone,

I have searched for similar problems in the forum, but didn't find any situation exactly like this:

I have created a simple dynamic RLS on my PBI Desktop: UserID = USERNAME(), also tried with UserID = USERPRINCIPLENAME().

I tested that on "View as Role" and it worked as expected.

However, when I upload it to Power BI Report Server, all the charts show a "Blank" message.

So I went ahead and tested using a static RLS, like this: UserID = user@usercompany.com and it worked!

Any advice on what I have to do to solve the problem of the dynamic rls?

Re: Dynamic RLS works in Power BI Desktop, but does not in Power BI Service

FarhanAhmed — Tue, 30 Mar 2021 03:48:26 GMT

Did you add users in below

you can go to this by right-clicking reporting and then Manage-->

Add your users there and hopefully, all will be able to view charts and data that has been assigned to them.

Re: Dynamic RLS works in Power BI Desktop, but does not in Power BI Service

RodrigoMachado — Tue, 30 Mar 2021 12:27:04 GMT

FarhanAhmedthank you for you answer. I've added myself to the Row level security, but all cards show a message of "blank" and all charts are blank.

When I use the "View as Role" in the Power BI Desktop the dynamic RLS works. When I upload it to the report server it does not, and when I download the version I just uploaded and test the View as Role again it does not work anymore...

Re: Dynamic RLS works in Power BI Desktop, but does not in Power BI Service

Icey — Thu, 01 Apr 2021 09:49:03 GMT

Hi RodrigoMachado ,

Based on my test, if the user has no access, the report visuals should show as below:

And only if the user has access but no corresponding data in the report, then some visuals will show as this:

However, when I upload it to Power BI Report Server, all the charts show a "Blank" message.

I can't reproduce your issue of showing "Blank" message.

What's the version of your Report Server? My test version is:

Power BI Report Server: 1.10.7698.27886 (January 2021)

Power BI Desktop (Optimized for Power BI Report Server): 2.88.2361.0 (January 2021).

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.