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

[Avennite]

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.

[josef78]

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

[Avennite]

I need this to work with pbix report. 

[josef78]

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

[Avennite]

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. 

[Anonymous · 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.

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

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.

[josef78]

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

[Anonymous]

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.

[Avennite]

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?