Problem embedding PowerBi Report in Sharepoint 2013

[EricPoirierCBRE]

I'am trying to display a Power BI report (hosted in a Premium workspace) into a Sahrepoint 2013 page.

As I haven't found PowerBI WebPart in this version of Sharepoint, I used iframe pattern.

It works, but users are prompted for sign-in to have report displayed.

This is an issue for me because this Sharepoint is also used by external users and when they try to sign-in they can't access our corporate SSO. So they can't access the report.

Is there a way to implement a Power BI report in Sharepoint 2013 avoiding this re-sign-in ?

[collinq · Accepted solution]

Hi @EricPoirierCBRE ,

In your setup, they will have to sign in because you are not passing the signed-on credentials from your SharePoint sign-on to your Power BI.  Therefore, Power BI will have to authenticate on its own each time.

Since you are using an older version of SharePoint I would reverse the way you are thinking about this.  Rather than try to put the Power BI into SharePoint, I suggest that you share the get the sharing link from the Power BI report and put that link into SharePoint and then the users hit the link and it will open Power BI directly and that will not require the sign-on (since you are using Premium and I assume that you have the sharing set up for external users).

[EricPoirierCBRE · Accepted solution]

Thanks for this solution. At this time public sharing seems not to be available but I'll get in touch with our PowerBi Administrator for that.

[collinq · Accepted solution]

Hi @EricPoirierCBRE ,

In your setup, they will have to sign in because you are not passing the signed-on credentials from your SharePoint sign-on to your Power BI.  Therefore, Power BI will have to authenticate on its own each time.

Since you are using an older version of SharePoint I would reverse the way you are thinking about this.  Rather than try to put the Power BI into SharePoint, I suggest that you share the get the sharing link from the Power BI report and put that link into SharePoint and then the users hit the link and it will open Power BI directly and that will not require the sign-on (since you are using Premium and I assume that you have the sharing set up for external users).