Skip to main content
cancel
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.

Reply
Avennite
Regular Visitor

I want to load a Power BI Reporting Server Report inside of a webforms application

I have a report that resisders on Power Bi Reporting Server. I need to be able to load this report inside of a web forms application. The documentation online claims i can use the ReportViewer control from SSRS, but that does not seem to work. I need to render this in a way where the authentication happenas through a master account and not throu AD. How would I do this? I need the authentication to happen in the background and be seamles to the user.

1 ACCEPTED SOLUTION

Hi @Avennite ,

If you configured the authentication method for PBIRS as Windows integrated authentication (RSWindowsNTLM), you can automatically log in to the PBIRS web page using the AD user currently logged in to that computer so that the user does not have to enter login information when opening a report.

 

Please try below steps:

1. Open CMD, type inetcpl.cpl, enter.

2.  Internet Properties->Security, select Local Intranet, click sites, add PBIRS web page to Local Intranet.

vbinbinyumsft_0-1708332223712.jpeg

 

3. Click Custom level, make sure your current User Authentication selection is Automatic logon only in Intranet zone (this is the default).

vbinbinyumsft_1-1708332237156.jpeg

 

4. You could append PBIRS pages to the local intranet via domain policy push, eliminating the need to manually append from each client.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
josef78
Memorable Member
Memorable Member

You need this for paginated report (rdlx), or power bi report (pbix)?

I need this to work with pbix report. 

ReportViewer (mentioned below) is only for paginated reports.
For interactive Power BI Reports on Report Server, is only option - embed in iframe, see:

Embed a Power BI Report Server report using an iFrame in SharePoint Server - Power BI | Microsoft Le...

Is there another way of doing this where the user does not have to authenticate to see the reports? i need this to be seamles to the end user. 

Hi @Avennite ,

If you configured the authentication method for PBIRS as Windows integrated authentication (RSWindowsNTLM), you can automatically log in to the PBIRS web page using the AD user currently logged in to that computer so that the user does not have to enter login information when opening a report.

 

Please try below steps:

1. Open CMD, type inetcpl.cpl, enter.

2.  Internet Properties->Security, select Local Intranet, click sites, add PBIRS web page to Local Intranet.

vbinbinyumsft_0-1708332223712.jpeg

 

3. Click Custom level, make sure your current User Authentication selection is Automatic logon only in Intranet zone (this is the default).

vbinbinyumsft_1-1708332237156.jpeg

 

4. You could append PBIRS pages to the local intranet via domain policy push, eliminating the need to manually append from each client.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Not sure on PBI RS, probably no. Maybe only when use anonymous access on whole RS portal.

v-binbinyu-msft
Community Support
Community Support

Hi @Avennite ,

Please refer this document: Use WebForms ReportViewer control - SQL Server Reporting Services (SSRS) | Microsoft Learn , hope it is helpful for you.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I have done this originally. This does not work. I get the following error when the username and password get passed in. When I google this error everyone claims that the control does not support powerBI reports.  Can you give me a sample in c# of this control being configured to work with powerBI Reporting server report?image.png

Helpful resources

Announcements
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

PBI_APRIL_CAROUSEL1

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.