Forum Discussion
melwakil
8 years agoFrequent 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
- 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.
6 Replies
- pbxHelper VYes 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.- melwakilFrequent VisitorThanks pbx, I will try the new web part, and let you know the result
- v-yulgu-msftMicrosoft Employee
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
- melwakilFrequent VisitorThanks 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
- pbxHelper VKerberos my friend, Kerberos is what you need.