topic Re: Embedded power Bi server reports into SharePoint in Report Server

Embedded power Bi server reports into SharePoint

melwakil — Wed, 03 Jan 2018 13:29:11 GMT

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

Re: Embedded power Bi server reports into SharePoint

pbx — Wed, 03 Jan 2018 15:22:51 GMT

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-viewer-web-part/

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.

Re: Embedded power Bi server reports into SharePoint

v-yulgu-msft — Thu, 04 Jan 2018 02:36:46 GMT

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

Re: Embedded power Bi server reports into SharePoint

melwakil — Thu, 04 Jan 2018 03:12:42 GMT

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

Re: Embedded power Bi server reports into SharePoint

pbx — Thu, 04 Jan 2018 03:32:46 GMT

Kerberos my friend, Kerberos is what you need.

Re: Embedded power Bi server reports into SharePoint

melwakil — Thu, 04 Jan 2018 03:55:14 GMT

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

Re: Embedded power Bi server reports into SharePoint

melwakil — Thu, 04 Jan 2018 03:56:50 GMT

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