The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Dear Community,
We are currently using an on-premises ReportServer, with PowerBI, and are exploring options to authenticate our users through a Single Sign-On (SSO) IdentityProvider. In our case, we are utilizing Keycloak, and we would like to use either SAML or OAuth (OIDC) as the authentication type.
We are seeking advice on how to achieve this.
Is there anyone who has implemented this using OIDC or SAML? Are there alternative methods we could consider? Any guidance would be greatly appreciated.
Thank you!
Solved! Go to Solution.
Hi,@nickibrochner .I am glad to help you.
According to your description, you want to set up SSO (single sign-on) in power BI Report Server
Even though I don't have experience in trying this, I would like to offer you some help.
Here are some of my suggestions.
I found the case study article about configuring SSO in SSRS and I noticed that this article also uses the official case study link you provided.
URL:
SSRS Custom Security with Single Sign-on
SSRS shares similarities with Power BI Report Server, in particular they both act as local report servers providing report management, scheduling and subscription functionality (with a different focus on report types, Power BI report server also supports pbix files)
I also found other issue about report server setup SSO.
URL:
setup SSO for SSRS 2019 WEB PORTAL - Microsoft Q&A
For report servers, Microsoft recommends using custom security extensions.
URL:
Configure Power BI Report Server with Microsoft Entra application proxy - Power BI | Microsoft Learn
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous,
Thanks for your great and probably useful reply. I will dive into your references and hopefully it will end up being just what we were looking for.
Kind regards,
Nicki Wassmann Brøchner
Hi,@nickibrochner .I am glad to help you.
According to your description, you want to set up SSO (single sign-on) in power BI Report Server
Even though I don't have experience in trying this, I would like to offer you some help.
Here are some of my suggestions.
I found the case study article about configuring SSO in SSRS and I noticed that this article also uses the official case study link you provided.
URL:
SSRS Custom Security with Single Sign-on
SSRS shares similarities with Power BI Report Server, in particular they both act as local report servers providing report management, scheduling and subscription functionality (with a different focus on report types, Power BI report server also supports pbix files)
I also found other issue about report server setup SSO.
URL:
setup SSO for SSRS 2019 WEB PORTAL - Microsoft Q&A
For report servers, Microsoft recommends using custom security extensions.
URL:
Configure Power BI Report Server with Microsoft Entra application proxy - Power BI | Microsoft Learn
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.