Skip to main content

Power BI

Planned

Embed Power BI Report Server reports into extranet apps

Vote (501) Share
's profile image

on 07 Jul 2017 00:23:51

Allow Embedding of Power BI Report Server Reports for Extranet Apps. Because of our clients needs data cannot leave our servers and be put on the cloud. Our existing SSRS reports are displayed using a report viewer object, however this will not work for PBIX. We need to ability to embed PBIX and display it externally. Is this going to be possible with Power BI report Server?

Administrator on 05 Jun 2018 07:19:05

Wanted to post an update to one of the pieces called out for this item - In a future update for the product, we're planning to do work to introduce support for ADFS/AAD in Power BI Report Server, and at the same time do work to enable your app to override user authentication in a secure way.

Comments (59)
's profile image Profile Picture

edb2c4a2 42ab-4698-8729-6ef234850b19 on 05 Jul 2020 23:08:16

RE: Embed Power BI Report Server reports into extranet apps

What is the timeline for releasing a full featured ReportViewer for Power BI Report Server?

's profile image Profile Picture

d5298c22 ae2c-474e-bd95-c4a618a2c45b on 05 Jul 2020 23:02:23

RE: Embed Power BI Report Server reports into extranet apps

Are there any plans to provide oauth support to Power BI Report Server? The scenario here is embedding content in to other apps, ideally we could pass a token with permission to Power BI Report Server from the embedding application.

's profile image Profile Picture

31f8cf47 55d3-4645-9281-25ed6ab8b6c3 on 05 Jul 2020 23:01:44

RE: Embed Power BI Report Server reports into extranet apps

Today we are using SharePoint as a internet facing portal and integrating reports into the portal. Different customers view the reports which gets filtered by company. The SharePoint site is also requiring client side certificates which resides on the users smart card. That is the base of our authentication and requires some custom authentication mekanism.
Today we have 20 reports in the portal and approximately 200 users devided into 25 customers. The customers can se each others data on a high level but on a lower level the data needs to be filtered so only customers see their own data.
We would like to get rid of SharePoint and create a lightweight custom ASP.Net site with custom authentication using client certificates and simple user management. To embed the report we would like to either use iFrames with the ability to filter reports but it would be even better to be able to use the JS API to more seamlessly integrate the reports.

's profile image Profile Picture

799a2f7d 62bc-41e6-b24f-e5ca45a3b3b6 on 05 Jul 2020 23:01:19

RE: Embed Power BI Report Server reports into extranet apps

Thanks Riccardo, our team is very much looking forward to being able to embed Power BI dashboards using custom Auth and as a mobile APP, Power BI visuals are nicer than any other competitor's. Thanks for letting us know you are planning on this.

's profile image Profile Picture

b5f3a381 1adb-48df-bfe6-c9e69d60f547 on 05 Jul 2020 23:00:55

RE: Embed Power BI Report Server reports into extranet apps

Will this be making it into the GA release of the Aug preview?

's profile image Profile Picture

f937d8bb c9ec-4d90-aec2-1e425d6870f6 on 05 Jul 2020 22:59:47

RE: Embed Power BI Report Server reports into extranet apps

I also have a need to provide reporting to external customers. Currently, we serve report to users as follows:
1) User logs into an ASP.NET Web Forms app using a custom authentication service that is similar to forms authentication.
2) They select a report from a navigation control, configure available parameters, and run it.
3) The report is viewed via the ReportViewer control.

The reports are authored against SQL and SSAS data sources. This is a multi-tenant SaaS application with multiple customers' data residing in the same tables. Because reports and queries are executed using stored service account credentials, we do not not rely on the databases to enforce row/cell/dimension security. Instead, we limit access to data by passing account number and user number parameters to the reports from parameter pages and as part of drillthroughs. Through the use of ReportViewer event handlers, we verify that an active session is present and that the user hasn't tampered with the security parameters in an attempt to gain access to another account's data.

I would like to use the same approach for embedded PowerBI reports via Power BI Report Server and a control similar to the Reporting Services ReportViewer. Is this on the roadmap?

's profile image Profile Picture

5d1de293 43ce-4da2-8f78-572e1a913511 on 05 Jul 2020 22:55:59

RE: Embed Power BI Report Server reports into extranet apps

Embedded reports with row level and tab level security by user and role would be amazing.

's profile image Profile Picture

b2cf68e2 3420-4a3c-b4d1-acd66deefc15 on 05 Jul 2020 22:53:10

RE: Embed Power BI Report Server reports into extranet apps

Allow for reports to be embedded in a similar manner to powerbi.com using an on premise version of PBI Report Server.

's profile image Profile Picture

a9fbd96b 455e-43e7-b5ad-52756c10bc66 on 05 Jul 2020 22:53:07

RE: Embed Power BI Report Server reports into extranet apps

Ideally I'd like a local power BI report server fed from our on site tabular SSAS instance. Currently our externally hosted sites have SSRS reports access report servers which aren't exposed to the internet. I don't think this is possible with Iframes as the URL won't be aware of the report server URL. Can PBIX files be used with something like a standard ReportViewer .NET object?