topic Re: I want to load a Power BI Reporting Server Report inside of a webforms application in Report Server

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

Avennite — Thu, 01 Feb 2024 13:37:42 GMT

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.

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

Anonymous — Fri, 02 Feb 2024 06:45:17 GMT

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.

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

Avennite — Fri, 02 Feb 2024 14:07:03 GMT

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?

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

josef78 — Sun, 04 Feb 2024 21:05:21 GMT

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

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

Avennite — Mon, 05 Feb 2024 15:51:57 GMT

I need this to work with pbix report.

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

josef78 — Tue, 06 Feb 2024 09:26:33 GMT

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 Learn

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

Avennite — Tue, 06 Feb 2024 14:21:44 GMT

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.

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

josef78 — Fri, 09 Feb 2024 18:29:19 GMT

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

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

Anonymous — Mon, 19 Feb 2024 08:46:45 GMT

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.