topic PowerBI Report server integration with OPENID connect in Report Server

PowerBI Report server integration with OPENID connect

rajaniesh — Tue, 30 Apr 2019 15:34:55 GMT

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

Re: PowerBI Report server integration with OPENID connect

luisrh — Tue, 30 Apr 2019 23:07:36 GMT

You should create your own authentication provider - We did that to manage SSO - We did that a while ago and had to modify for PBI RS - it works and you can front end authentication as well as manage authorization if you needed to set those policies in SSRS as users log in. MSFT has since provided a sample specific for PBI RS. Here is the link https://github.com/Microsoft/Reporting-Services/tree/master/CustomSecuritySample

good luck.

Luis

Re: PowerBI Report server integration with OPENID connect

Anonymous — Wed, 01 May 2019 11:36:59 GMT

Thank YOU so much for a quick reply.Do you have some sample which works with openId connect.
I have one more question. Do we require ADFS to implement it or we just have to create custom extension and that is it.

Re: PowerBI Report server integration with OPENID connect

luisrh — Wed, 01 May 2019 15:47:00 GMT

I don't believe there is a sample and I don't have one. You don't need to use ADFS for your solution. The auth provider you write would be managing all of that. This sample should give you enough to go on. If I find an OpenID implementation, I will post here. This code should be able to give you a good idea of how to implement.

thanks