topic Re: Power BI Report Server with custom security using row level security in Report Server

Power BI Report Server with custom security using row level security

oliviernicollet — Fri, 24 Aug 2018 13:59:20 GMT

Hello,

I tryed the sample custom security https://github.com/Microsoft/Reporting-Services/tree/master/CustomSecuritySample. This works fine except the user i get from DAX is NT SERVICE\PowerBiReportServer and not user from database. This make it impossible to use Row Level Security with USERPRINCIPALNAME() or USERNAME().

Is there any solution to get the user of custom security in report?

oliviernicollet — Mon, 27 Aug 2018 06:44:31 GMT

Anonymous — Thu, 30 May 2024 07:42:44 GMT

Hi, I implemented Custom Security with https://github.com/Microsoft/Reporting-Services/tree/master/CustomSecuritySample. But once I logged in with admin User, not able to upload any report. It is giving me error mentioned below .

But with windows authentication, i am able to upload report.. Can you please help me resolve this issue