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

[Anonymous]

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?

[v-qiuyu-msft]

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...

Best Regards,
Qiuyun Yu

[Bustardo]

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.

[mgmeyer]

@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!

[Bustardo]

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.

[jtarquino]

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-appli...

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...)

[DmitryK]

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-load...

[MSMS_MSMS]

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

[Bustardo]

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.

[agera111]

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

[Anonymous]

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/

[johncpratt]

@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".

[Anonymous]

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

[Anonymous]

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

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

[amassip]

Hello

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

[v-qiuyu-msft]

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