cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CHAITANYA9
New Member

How to customize login screen in on-premises powerbi report server

My on-premises powerbi report server is displaying a pop-up for user credentials. how to change sign-in screen from pop-up to a customized as in below screenshot?

CHAITANYA9_0-1620270512782.png

 

2 ACCEPTED SOLUTIONS
AbhiSSRS
Impactful Individual
Impactful Individual

This is a bit tricky and needs some customization. Out of the below steps first please do only Logon page change and deploy. In case you dont need custom sign -in that should suffice, in case that dsn't work there are other steps below too :

 

https://github.com/chunlampang/ms-ssrs-2014-custom-security

 

 

Download Custom Security samples for Reporting Services by Microsoft and configure Login page as per requirements. Change app.config app settings to reflect server URL

<applicationSettings>    <Microsoft.Samples.ReportingServices.CustomSecurity.Properties.Settings>      <!--<setting name="Microsoft_Samples_ReportingServices_CustomSecurity_localhost_ReportingService2015"          serializeAs="String">           

<value>http://servername/ReportsBI/browse/</value>        </setting>-->      <setting name="Database_ConnectionString" serializeAs="String">        <value>Data Source=XXXX;Initial Catalog=UserAccounts;Integrated Security=false;User Id=XXX;Password=XXX;</value>      </setting>    </Microsoft.Samples.ReportingServices.CustomSecurity.Properties.Settings>

    <add key="ValidationSettings:UnobtrusiveValidationMode" value="None" />

  </applicationSettings>

Compile the project and deploy below dlls at designated Power BI server locations :

\Program Files\Microsoft Power BI Report Server\PBIRS\PowerBI

Microsoft.Samples.ReportingServices.CustomSecurity.dll

Microsoft.Samples.ReportingServices.CustomSecurity.pdb


\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\bin

Microsoft.Samples.ReportingServices.CustomSecurity.dll

Microsoft.Samples.ReportingServices.CustomSecurity.pdb


\Program Files\Microsoft Power BI Report Server\PBIRS\Portal

Microsoft.Samples.ReportingServices.CustomSecurity.dll

Microsoft.Samples.ReportingServices.CustomSecurity.pdb

 

Deploy below additional file to Report Server which you have made as per your requirement :

C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer

Logon.aspx

 

Edit below config files for custom logon on Report Server :

\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer

 

rsreportserver,srvpolicy and web.config - these will need below entries
tags for LogonUSer,LogonDOmain and LogonCred


:\Program Files\Microsoft Power BI Report Server\PBIRS\Portal

RSPortal.exe.config

 

Insert Machine Key  Encryption and Decryption:

 

<system.web>

    <machineKey validationKey=’XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXD" decryptionKey="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX" validation="AES" decryption="AES" />

  </system.web>


C:\Program Files\Microsoft Power BI Report Server\PBIRS\PowerBI

<system.web>

    <machineKey validationKey=’XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXD" decryptionKey="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX" validation="AES" decryption="AES" />

  </system.web>

RSPowerBI.exe.config

 

Machine key can be generated from IIS/relevant mechanism( lookup on web)

 

These steps will have the Power BI ReportServer ready with Login :

 

 

 

View solution in original post

v-deddai1-msft
Community Support
Community Support

Hi @CHAITANYA9 ,

 

Please refer to the sample in https://mirkomaggioni.com/2020/11/28/implementing-custom-authentication-and-authorization-with-power...

 

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

 

Best Regards,

Dedmon Dai

View solution in original post

2 REPLIES 2
v-deddai1-msft
Community Support
Community Support

Hi @CHAITANYA9 ,

 

Please refer to the sample in https://mirkomaggioni.com/2020/11/28/implementing-custom-authentication-and-authorization-with-power...

 

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

 

Best Regards,

Dedmon Dai

View solution in original post

AbhiSSRS
Impactful Individual
Impactful Individual

This is a bit tricky and needs some customization. Out of the below steps first please do only Logon page change and deploy. In case you dont need custom sign -in that should suffice, in case that dsn't work there are other steps below too :

 

https://github.com/chunlampang/ms-ssrs-2014-custom-security

 

 

Download Custom Security samples for Reporting Services by Microsoft and configure Login page as per requirements. Change app.config app settings to reflect server URL

<applicationSettings>    <Microsoft.Samples.ReportingServices.CustomSecurity.Properties.Settings>      <!--<setting name="Microsoft_Samples_ReportingServices_CustomSecurity_localhost_ReportingService2015"          serializeAs="String">           

<value>http://servername/ReportsBI/browse/</value>        </setting>-->      <setting name="Database_ConnectionString" serializeAs="String">        <value>Data Source=XXXX;Initial Catalog=UserAccounts;Integrated Security=false;User Id=XXX;Password=XXX;</value>      </setting>    </Microsoft.Samples.ReportingServices.CustomSecurity.Properties.Settings>

    <add key="ValidationSettings:UnobtrusiveValidationMode" value="None" />

  </applicationSettings>

Compile the project and deploy below dlls at designated Power BI server locations :

\Program Files\Microsoft Power BI Report Server\PBIRS\PowerBI

Microsoft.Samples.ReportingServices.CustomSecurity.dll

Microsoft.Samples.ReportingServices.CustomSecurity.pdb


\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\bin

Microsoft.Samples.ReportingServices.CustomSecurity.dll

Microsoft.Samples.ReportingServices.CustomSecurity.pdb


\Program Files\Microsoft Power BI Report Server\PBIRS\Portal

Microsoft.Samples.ReportingServices.CustomSecurity.dll

Microsoft.Samples.ReportingServices.CustomSecurity.pdb

 

Deploy below additional file to Report Server which you have made as per your requirement :

C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer

Logon.aspx

 

Edit below config files for custom logon on Report Server :

\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer

 

rsreportserver,srvpolicy and web.config - these will need below entries
tags for LogonUSer,LogonDOmain and LogonCred


:\Program Files\Microsoft Power BI Report Server\PBIRS\Portal

RSPortal.exe.config

 

Insert Machine Key  Encryption and Decryption:

 

<system.web>

    <machineKey validationKey=’XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXD" decryptionKey="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX" validation="AES" decryption="AES" />

  </system.web>


C:\Program Files\Microsoft Power BI Report Server\PBIRS\PowerBI

<system.web>

    <machineKey validationKey=’XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXD" decryptionKey="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX" validation="AES" decryption="AES" />

  </system.web>

RSPowerBI.exe.config

 

Machine key can be generated from IIS/relevant mechanism( lookup on web)

 

These steps will have the Power BI ReportServer ready with Login :

 

 

 

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.