Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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?

 

 

15 REPLIES 15
v-qiuyu-msft
Community Support
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

 

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

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.

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

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

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

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.

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
Not applicable

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/

 

@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
Not applicable

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

Anonymous
Not applicable

 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
Helper I
Helper I
v-qiuyu-msft
Community Support
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors