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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
pavel118
Frequent Visitor

domain authorization

Good afternoon
Can I configure domain authorization in PBIRS. I want the user to not enter a username and password when logging in.
3 REPLIES 3
v-jtian-msft
Community Support
Community Support

Hello,@SolomonovAnton ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.

Hi,@pavel118 .I am glad to help you.
In fact the advice given by SolomonovAnton is detailed and I would like to add some additional documentation on the subject, which I hope will be of help to you.
1.Configure Kerberos In Power BI Report Server

Configure Kerberos to use Power BI reports - Power BI | Microsoft Learn

Configure Kerberos authentication to support delegation so that users can automatically log on with their Windows credentials


You need to understand the common authentication methods in Power BI Rpoort Server and know the differences between them
The official recommendation is to use the Windows authentication method.

Authentication in a report server - SQL Server Reporting Services (SSRS) | Microsoft Learn

vjtianmsft_0-1730685598464.png


URL:
About Service Principal Names

vjtianmsft_1-1730685628998.png


I hope the following related issue is helpful to you.
URL:

Avoid login username and password prompt for Power... - Microsoft Fabric Community

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

SolomonovAnton
Solution Supplier
Solution Supplier

Yes, you can configure domain (Windows) authentication in Power BI Report Server (PBIRS) to allow users to log in without entering a username and password, provided they are on the same domain and using a browser that supports integrated authentication.

Steps to Configure Domain Authentication in PBIRS:

  1. Enable Windows Authentication in PBIRS:

    • Open the Reporting Services Configuration Manager on the server where PBIRS is installed.
    • Go to Web Service URL and Web Portal URL sections.
    • Ensure that Windows Authentication is enabled.
  2. Set up Kerberos Authentication (if needed):

    • Kerberos allows for seamless authentication across servers without re-entering credentials.
    • Configure SPNs (Service Principal Names) for the PBIRS URL if it’s running under a domain service account.
    • This step is optional but might be necessary if your setup involves multiple servers or if users still get prompted.
  3. Configure Internet Explorer or Edge to Allow Integrated Authentication:

    • In Internet Explorer or Edge, go to Settings > Internet Options > Security > Local Intranet.
    • Add your PBIRS server URL to the Local Intranet zone.
    • Ensure that Automatic logon only in Intranet zone is enabled.
    • This step may vary for other browsers, but similar options are often available.
  4. Modify Group Policies (if applicable):

    • Use Group Policy to push these browser settings across your organization if required.
    • Go to Computer Configuration > Administrative Templates > Windows Components > Internet Explorer > Internet Control Panel > Security Page.
    • Add the PBIRS URL to the Intranet Zone for seamless authentication.
  5. Check Firewall and Network Settings:

    • Ensure that the users’ systems are connected to the same network domain and that no firewalls are blocking the necessary communication ports.

With these steps, users accessing PBIRS on the same domain should be automatically authenticated without needing to enter their credentials each time.

If my message helped solve your issue, please mark it as Resolved! If it was helpful, consider giving it a Kudos!

I understand correctly that after creating the SPN you need to configure delegation in the report server service account.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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