Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
9 | |
5 | |
3 | |
3 |