topic Re: SharePoint on premise to Power BI embedded report forcing authentication twice in Report Server

SharePoint on premise to Power BI embedded report forcing authentication twice

andersonp45 — Mon, 22 Nov 2021 20:16:57 GMT

Hello I have a sharepoint on premise solution that embeddeds a power bi report server url in a sharepoint site. It works fine, but when logging into SP and hitting iframe I am forced to login again. Can anyone help?

Re: SharePoint on premise to Power BI embedded report forcing authentication twice

d_gosbell — Tue, 23 Nov 2021 11:23:41 GMT

This does not sound right. By default both Sharepoint and Power BI Report Server use integrated windows authentication so there should not be any login prompts at all. Are your servers in a different domain to your users or have you implemented some sort of custom authentication?

Re: SharePoint on premise to Power BI embedded report forcing authentication twice

v-henryk-mstf — Thu, 25 Nov 2021 02:19:02 GMT

Hi andersonp45 ,

For your description, if you're working with SharePoint Online, Power BI Report Server must be publicly accessible. In SharePoint Online, the Power BI Web part that works with the Power BI service won't work with Power BI Report Server.

After getting the URL, you need to add the query string parameter to embed the report in the SharePoint iFrame
For example

https://myserver/reports/powerbi/Sales?rs:embed=true

For more details, you can read related document.

Embed a Power BI Report Server report using an iFrame in SharePoint Server

If the problem is still not resolved, please point it out and provide related operation screenshoots. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: SharePoint on premise to Power BI embedded report forcing authentication twice

andersonp45 — Mon, 20 Dec 2021 21:11:42 GMT

Hello this is an on-premise Power BI Report Server; so we would not register. The SharePoint on-premise is in the same domain as PB Report Server. But again; when passing url from SP to Report Server and adding rs:embed=true as well below; i am still forced to login twice. both servers are https servers; they are seperate boxes. can you help?

Re: SharePoint on premise to Power BI embedded report forcing authentication twice

andersonp45 — Mon, 20 Dec 2021 21:13:10 GMT

so both boxes are on premise. we are using a proxy for them to be accessible to the outside world; but whether accessing internally or externally - authentication for the sharepoint site is required - which is ok - but when accessing the link for the report server - another authentication is being required.