Can I integrate Power BI reports into my web application built with Laravel and React Js

[Anonymous]

I have built an application using Laravel and React Js and I have been looking into how I can integrate the Power BI reports into my web application. So far I don't have any insights show I can integrate them. Please give me some insights regarding this.

[ranbeermakin]

Hi @Anonymous 

Couple of things for Power BI Embedded.

1. You can setup code in your PHP to get tokens, query this code using JS and embed your Power BI report.

2. You can refer to this blog post: baby steps to embed Power BI reports. This uses master user account approach.

https://bigintsolutions.com/2018/08/02/baby-steps-to-embed-your-power-bi-reports/

3. This is critical: It's not free to use Power BI Embedded in production env. The cost is min USD 700 per month pay per hour basis. When you don't need it switch it off.

Let me know if this answers your question.

Ranbeer

Please accept the post if it solves your problem.

[Greg_Deckler]

Power BI Embedded, it is just javascript to embed. Or you can use Publish to Web and an iframe, but since you are a Web Artisan, you probably don't do iframes...

[Anonymous]

So what you are suggesting is that I generate the iframe from inside my power BI save that in the database and then display them in the frontend???

[Greg_Deckler]

No, I am recommending that you use Power BI Embedded: 

• https://azure.microsoft.com/en-us/services/power-bi-embedded/
• https://powerbi.microsoft.com/en-us/power-bi-embedded/
• https://microsoft.github.io/PowerBI-JavaScript/demo/v2-demo/index.html

If you so choose, you can publish your Power BI report to the Service. You can then go to the Report in the Service, click the ellipses in the ribbon, choose Embed and then choose Publish to Web (public). It will present you with an embed url link as well as an iframe version of the same. It will look like:

<iframe width="800" height="600" src="https://app.powerbi.com/view?r=eyJrIjoiMTMwOTljMjEtMGUwYy00ZGNmLWEyMzktODdkZmQ0YzIyZmZkIiwidCI6IjRhM..." frameborder="0" allowFullScreen="true"></iframe>

Since Laravel is the PHP Framework for Web Artisans the framework might ban the use of iframes. Hard to know.

[Anonymous]

Yes, I have done that and I have that <iframe>...</iframe> to integrate to my front end HTML.

I was talking about https://docs.microsoft.com/en-us/rest/api/power-bi/reports/getreportsingroup

Can't I use these Rest API endpoints to integrate the reports into my application?

[Greg_Deckler]

Um, no, that would completely negate the purpose of Power BI Embedded. The REST API is really there for administration. You can get the embed url but unless you have used Publish to Web or you go through all the authentication token stuff for Power BI Embedded then it won't be there or won't do you much good. You cannot just use the REST API to embed reports.