cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
melwakil Frequent Visitor
Frequent Visitor

Embedded power Bi server reports into SharePoint

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

1 ACCEPTED SOLUTION

Accepted Solutions
pbx Member
Member

Re: Embedded power Bi server reports into SharePoint

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.
6 REPLIES 6
pbx Member
Member

Re: Embedded power Bi server reports into SharePoint

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.
Community Support Team
Community Support Team

Re: Embedded power Bi server reports into SharePoint

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.

1.PNG

 

Best regards,

Yuliana Gu

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
melwakil Frequent Visitor
Frequent Visitor

Re: Embedded power Bi server reports into SharePoint

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 Member
Member

Re: Embedded power Bi server reports into SharePoint

Kerberos my friend, Kerberos is what you need.
melwakil Frequent Visitor
Frequent Visitor

Re: Embedded power Bi server reports into SharePoint

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
melwakil Frequent Visitor
Frequent Visitor

Re: Embedded power Bi server reports into SharePoint

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