Power BI Report Server Embedding

[Maverik91]

Hello Power BI Community,

I’m working on a custom application that requires embedding Power BI reports hosted specifically on Power BI Report Server (PBRS), our on-premises solution.

We recognize that PBRS differs significantly from the Power BI Service (Cloud) in terms of architecture and security, relying primarily on Windows Authentication and Kerberos Constrained Delegation for SSO.

Our main question is about programmatic embedding and interactivity:

Does the Power BI JavaScript API support embedding reports hosted on Power BI Report Server?

If JavaScript API embedding isn’t an option for PBRS, what are the best practices for achieving embedding?

Thank you,  

Marco

[Vanchy_Liao · Accepted solution]

@Maverik91 ,

If you want to embed a RS pbi report to a web site or browswer like plugin, use the suggestion from @Nabha-Ahmed.

For futher information about embedding, you can see my post here.

I think MS should build a document to describe the available parameters when embedding RS PBI to iframe, escpecially for RS.

[V-yubandi-msft]

Hi @Maverik91 ,

I wanted to check if you had the opportunity to review the information provided by @Nabha-Ahmed, @lbendlin, @tayloramy . Please feel free to contact us if you have any further questions. 
 

Thank you and continue using Microsoft Fabric Community Forum.

[Nabha-Ahmed]

Hi @Maverik91 

The Power BI JavaScript API is not fully supported for reports hosted on Power BI Report Server (on‑premises). edureka.co

What to do instead:

1. Use an iframe to embed the report in your app, e.g.:  

<iframe src="https://your‑report‑server/reports/powerbi/YourReport?rs:Embed=true" width="…" height="…"></iframe>

1. 1. Ensure your on‑premises authentication (Windows Auth / Kerberos) is configured so users are SSO’ed through.

   2. If you require advanced interactivity (JavaScript events, filters, bookmarks) that the JS API provides, consider using the cloud version Power BI Service or a hybrid approach.

Hope that helps clear things up.

[tayloramy]

Hi @Maverik91, 

If this is internal, then you can ensure that everyone has permissions to view the report on the report server, and then embed it in an iFrame with a query string of ?rs:embed=true at the end of the URL. THis is outlined here: Embed a Power BI Report Server report using an iFrame in SharePoint Server - Power BI | Microsoft Le...

If this is external and not on your org's network, then it gets messy. You would need to open up firewalls and port forward the report server so it is accessible outside your network. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[lbendlin]

Sounds like a losing battle from the get-go.  You would have to completely reinvent the entire authentication layer .

Hopefully this is for an internal audience?

[Maverik91]

We are trying to figure out what might be the most suitable solution. We are open to any suggestions.😅