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.

View solution in original post

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.

View solution in original post

v-yulgu-msft Super Contributor
Super Contributor

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 434 members 4,323 guests
Please welcome our newest community members: