Power BI Report Server Embed API Alternative

[LucasGA]

Hi,

I’m looking for method to enable users of our application to be able to view an embedded Power BI report without being prompted for a login. The report has sensitive data so I can not simply make the report publicly available. As users are authenticated via the application there is no need for a second Power BI authentication.

If I use the Power BI cloud service (i.e. https://app.powerbi.com/home) I am able to harness the power of the Power BI Embed API and with a generated accessToken I can display the report without the user having to login again. However, our client would like to use Power BI Report Server in order to host all the data on their own servers.

As I understand the Power BI Embed API feature is not available on Power BI Report Server. 

Is there any alternate method I can use to give the user a seamless user experience and avoid the double login?

i.e. Log the user into Power BI in the background as they log into the application (assuming I have their Power BI credentials), then log them back out as they logout the application.

Any help would be appreciated,

Lucas

[d_gosbell]

---

@LucasGA wrote:

Is there any alternate method I can use to give the user a seamless user experience and avoid the double login?

---

if you are using the default windows authentication there should not be any double login. The users windows credentials will be seamlessly passed through and you can embed reports using simple iframes when using Report Server.

[gustavoandrade]

Hi @d_gosbell 

Where do I mark to select as Windows Credentials?

Is it necessary to be a user in an AD or can it be local? *My network is a mix of AD users and local users (where VPN is unstable)

[d_gosbell]

---

@gustavoandrade wrote:

Where do I mark to select as Windows Credentials?

---

You should not need to mark anything, it's the default configuration. I suppose you would need to make sure your server is domain joined, but that is the only pre-requisite I can think of and that is standard practice for most organisations.

---

@gustavoandrade wrote:

Is it necessary to be a user in an AD or can it be local? *My network is a mix of AD users and local users (where VPN is unstable)

---

I pretty much exclusive use AD users, but I guess it would also work with local accounts. It would depend on the scenario though as you can only map a local account to another local account. You can't map domain accounts to a local one.