Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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
Solution Sage
Solution Sage

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 @Anonymous ,

 

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

 

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

3 REPLIES 3
v-deddai1-msft
Community Support
Community Support

Hi @Anonymous ,

 

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

 

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

AbhiSSRS
Solution Sage
Solution Sage

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 :

 

 

 

I am new to Power BI, sorry for some basic questions.
I am using Power BI Report Server 15.0.1111.115 in Windows Server 2012 R2 Standard.

I am trying to customize default pop-up login in order to only allow specific Active Directory accounts log in to Power BI.
Is this article conform to what I want to do?
I cannot find app.config mentioned in the beginning either in sample code downloaded or in report server folder.
Where should app.config be in?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.