topic Re: How to access PowerBI Reports hosted on-premise in web application in Report Server

How to access PowerBI Reports hosted on-premise in web application

Anonymous — Thu, 08 Jun 2017 04:48:53 GMT

I am having a PowerBI Report uploaded to Reporting Server using On-Premise. i want to access this report in my web application.

How to achieve this step by step?

Is it possible to access the report using "http://<ServerName>/<Report Path>" url format?

Re: How to access PowerBI Reports hosted on-premise in web application

v-qiuyu-msft — Sat, 10 Jun 2017 03:13:57 GMT

Hi Anonymous,

From your description, it seems that you want to render the Power BI report which deployed to Power BI report server in your web application, right?

Regarding this requirement, I have sent a email to consult it internally. Will update here once get feedback.

Best Regards,
Qiuyun Yu

Re: How to access PowerBI Reports hosted on-premise in web application

amassip — Mon, 12 Jun 2017 08:48:00 GMT

Hello

https://www.kasperonbi.com/embedding-power-bi-reports-with-power-bi-report-server/

Re: How to access PowerBI Reports hosted on-premise in web application

Anonymous — Mon, 26 Jun 2017 12:10:55 GMT

I use a URL like this

http://localhost/reports/powerbi/REPORTNAME?rs:Command=Render&rc:Toolbar=false

This renders without the navigation and other SSRS stuff. This seems to be the same as the

?rs:Embed=true

described in this article https://www.kasperonbi.com/embedding-power-bi-reports-with-power-bi-report-server/

Re: How to access PowerBI Reports hosted on-premise in web application

Anonymous — Wed, 05 Jul 2017 06:11:58 GMT

This is great for internal applications but want to use for extranet scenario.

could you please provide any work around for embedding internet application?

Re: How to access PowerBI Reports hosted on-premise in web application

Anonymous — Wed, 05 Jul 2017 06:22:49 GMT

Could you please provide work around to connect internet application for the same?

Re: How to access PowerBI Reports hosted on-premise in web application

v-qiuyu-msft — Thu, 06 Jul 2017 01:45:28 GMT

Hi Guys,

Please take a look at Petebro's reply in this thread: http://community.powerbi.com/t5/Report-Server/Embedding-Power-BI-Reports-with-Power-BI-Report-Server-for/m-p/206283#M176

Best Regards,
Qiuyun Yu

Re: How to access PowerBI Reports hosted on-premise in web application

Bustardo — Thu, 06 Jul 2017 16:57:20 GMT

So basically there's no workaround for using this for internet applications and no update planned?

I was under the impression the power BI reports would function in a manner similar to a report viewer. Currently our application uses a Report viewer to render all the reports on the report server and the Iframe is essentially useless as the URL's aren't exposed to the internet.

Re: How to access PowerBI Reports hosted on-premise in web application

mgmeyer — Thu, 06 Jul 2017 17:12:29 GMT

Bustardo developer support and embeddability are on our backlog, if there is a scenario that you would like supported please submit and idea here so we can ensure it is considered when we get to it. Thanks!

Re: How to access PowerBI Reports hosted on-premise in web application

Bustardo — Thu, 06 Jul 2017 18:04:33 GMT

That's great. We are trying to decide how to proceed with our solutuon. Ideally I'd like a local power BI report server fed from our on site tabular instance. Currently our externally hosted sites have SSRS reports access report servers which arent exposed to the internet. I don't think this is possible with Iframes as the URL won't be aware of the report server URL.

Re: How to access PowerBI Reports hosted on-premise in web application

jtarquino — Fri, 07 Jul 2017 15:37:24 GMT

There is another option that you could use that is exposing your Power BI Report Server endpoints to the internet, you can achieve that using Azure Active Directoy Application Proxy https://docs.microsoft.com/en-us/azure/active-directory/active-directory-application-proxy-publish or Windows 2016 Web Application proxy https://docs.microsoft.com/en-us/windows-server/remote/remote-access/web-application-proxy/web-application-proxy-windows-server

I wrote an old blog post with some instructions for doing that for Azure AD (https://blogs.msdn.microsoft.com/jtarquino/2016/07/04/accessing-sql-server-reporting-services-mobile-reports-with-the-power-bi-app-from-the-internet-using-active-directory-application-proxy/)

Re: How to access PowerBI Reports hosted on-premise in web application

Bustardo — Tue, 11 Jul 2017 14:34:46 GMT

Thank you very much for your reply. I believe we are going to go with the Windows 2016 Web Application proxy to view Power BI Report Server visualizations of Live SSAS Tabular data. I wouldn't have known that was possible without your post.

Re: How to access PowerBI Reports hosted on-premise in web application

agera111 — Wed, 11 Oct 2017 15:34:28 GMT

Hi Guys,

I used this article and was able to publish PBI RS throught WAP. So authentication to RS works fine, but all reports shows 404.

thanks,

Oleksiy

Re: How to access PowerBI Reports hosted on-premise in web application

MSMS_MSMS — Sat, 19 May 2018 06:37:30 GMT

Hello Jaime,

Has anything regarding Azure preauthentication changed since now almost two years from your article? We would like to use Azure preauthentication to authenticate our mobile users that are using Power BI Mobile to access internal Power BI server. It works with passthrough authentication, but not with Azure preauthentication (same server name that works with passthrough authentication is not recognized by mobile app when using Azure preauthentication). Result is that our users need to use usernames and passwords (which they don't know, since we internally user smart cards), and we would like them to have SSO experience with same certificate based authentication to Azure that we use for other mobile services (mail, MDM, ... ).

Best regards, MSMS_MSMS

Re: How to access PowerBI Reports hosted on-premise in web application

johncpratt — Thu, 28 Jun 2018 15:20:37 GMT

Anonymous, thank you! The only precise answer I found online. I have confirmed that those URL parameters work with Power BI Report Server March 2018 release running on SQL Server 2016. I also confirmed that "rs:Embed=true" works exactly the same as "rs:Command=Render&rc:Toolbar=true".

Re: How to access PowerBI Reports hosted on-premise in web application

DmitryK — Tue, 17 Mar 2020 07:21:13 GMT

Looks like there are problems accessing published PowerBI reports, please have a look

https://community.powerbi.com/t5/Report-Server/Report-Server-with-AD-Application-Proxy-stuck-at-loading/m-p/506620/thread-id/7664/highlight/false