Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
Solved! Go to Solution.
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 :
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
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
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?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
8 | |
2 | |
2 | |
2 | |
2 |
User | Count |
---|---|
7 | |
5 | |
4 | |
3 | |
3 |