RLS not working after refresh ends

[Anonymous]

Hi,

I have set a RLS on power bi desktop [my column = username()].

When i view as the user on power bi desktop it works fine, but when i publish it to the service it works fine only until the refresh ends.

My refresh take about 1.5 hours so i can view the data in that time. 

After the refresh ends all i see is blank for all the visuals.

I checked for date as text datatype in the relevant tables but all is in the currect datatype.

Any suggestions?

[Anonymous]

Hi  @Anonymous ,

Please check the version of your Desktop, if it is not the latest version, please upgrad it to the latest one.

I found an issue: Visualization BLANK after refreshing page in Power BI service like yours, hope it could help you solve your problem.

Best Regards,

Liu Yang

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

[bcdobbs]

1) Have all the users been added to the RLS role in the service?

2) This might be the issue from here .

"Within Power BI Desktop, username() will return a user in the format of DOMAIN\User and userprincipalname() will return a user in the format of user@contoso.com.

Within the Power BI service, username() and userprincipalname() will both return the user's User Principal Name (UPN). This looks similar to an email address."

What format is in your column?

You can test by using it in a measure and dropping into a card visual to see what is being passed.