topic Row Level Security on power Bi Sever in Report Server

Row Level Security on power Bi Sever

Anonymous — Sun, 04 Apr 2021 11:01:21 GMT

Hi All,

I am using Power BI Desktop and have created a Pbix with Row Level security and it works fine. But when I upload this report on the Power BI Server, it shows below errors for all the visuals.
"To view content contact the dataset owner..."

Any help is appreciated.

Thanks

Re: Row Level Security on power Bi Sever

AbhiSSRS — Sun, 04 Apr 2021 11:31:17 GMT

Hi!

Could you please confirm if you are using userprincipalname:

"Be aware that username() has the format of DOMAIN\username within Power BI Desktop. Within the Power BI service and Power BI Report Server, it's in the format of the user's User Principal Name (UPN). Alternatively, you can use userprincipalname(), which always returns the user in the format of their user principal name, username@contoso.com. "

https://docs.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server

Re: Row Level Security on power Bi Sever

Anonymous — Sun, 04 Apr 2021 14:52:28 GMT

Hi ,

Yes I am using userprincipalname(), but on the Report Server it is not recognising.

Thanks

Re: Row Level Security on power Bi Sever

FarhanAhmed — Mon, 05 Apr 2021 06:02:35 GMT

Can you please share the screenshot of the error? are you getting this error in visuals?

Did you add your users to below

--> Right click on report and click Manage.

--> On Left side you will see "Row Level Security"

--> Click Add member to add users and click on the role you want to provide on RLS.

Re: Row Level Security on power Bi Sever

Anonymous — Mon, 05 Apr 2021 07:38:09 GMT

Many Thanks.. It worked

Regards