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

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.

Helper II
Helper II

PowerBI Report server integration with OPENID connect



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: 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?




Responsive Resident
Responsive Resident

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


good luck.


Not applicable

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.
Responsive Resident
Responsive Resident

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.


Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.