Embedded power Bi server reports into SharePoint

[melwakil]

Is it Possible to embed reports from Power Bi report server into SharePoint to be seen by the users who already part of the damin and authorized to see the reports ? is the IFRAME could pass their cerdentials without the window popup that appeared from the iframe that asking the user to enter his credentials again .

Thanks

[v-yulgu-msft]

Hi @melwakil,

To embed a PBI report from Power BI Report Server into SharePoint, you can append a querystring parameter of ?rs:Embed=true to report URL.

To avoid credential prompt, you could set "stored credential" under Data Sources tab.

Best regards,

Yuliana Gu

[melwakil]

Thanks v-yulgu , but i think the credential prompt appeared because pbirs trying to authorized the user either the user have a permission to see the report or not. So saveing credentials in the data source will not avoid the windows prompt

[pbx]

Kerberos my friend, Kerberos is what you need.

[melwakil]

Thanks pbx, Kerberos is used to delegate the user credentials between pbirs and the report data source in case the report and its data source are not in the same machine. I think it should be something in the web part inside sharePoint itself

[pbx · Accepted solution]

Yes it is. See here for details of how to embed various PBIRS reports to SharePoint.
https://whitepages.unlimitedviz.com/2017/09/sharepoint-and-the-new-ssrspbirs-native-mode-report-view...

However, the problem you are going to run into is those PBI reports will not render in IE because SharePoint by default serve pages in IE-10 compatibility mode and PBI only works with IE 11 and newer. You won't have that issue with Chrome though.

[melwakil]

Thanks pbx, I will try the new web part, and let you know the result