PowerBI Report server integration with OPENID connect
Hi, I want to deply PowerBI Report server in our OnPrem environement and use it a de facto Reporting platform. We do not use Active Directory but we use SSO (OpenID Connect based SSO). Now I am wondering how do I deploy PowerBI Report server in our environment. This article from Microsoft: https://docs.microsoft.com/en-us/sql/reporting-services/security/authentication-with-the-report-server?view=sql-server-2017 clearly states that SSO is not supported by PowerBI but states that "The report server hosting environment does not support ISAPI filters. If the SSO technology you are using is implemented as an ISAPI filter, consider using the ISA Server built-in support for RSASecueID or the RADIUS protocol. Otherwise, you can create an ISA Server ISAPI or an HTTPModule for RS, but it is recommended you use ISA Server directly." How do we use this option? Another point from the article states that : "Specify Custom only if you are deploying a custom authentication module that handles all authentication requests on the report server. You cannot use the Custom authentication type with the default Windows Authentication extension." Do we have custom security handler sample for this purpose? Another option I was thinking of to use ADFS but not sure if ADFS will work with Report server.? I am thinking Active Directory -->ADFS which federates to OpenID connect based Auth. Do we have any documentation regarding this? Regards Rajaniesh