In today’s data-driven world, the ability to visualize data in real-time is a powerful tool for any business. Microsoft Power BI is a top tool for creating interactive visualizations and gaining business insights. By integrating Power BI with React.js, you can embed these visualizations directly into your web applications. This guide will show you how to embed Power BI reports in your React.js apps using Power BI APIs.
Before starting the integration process, ensure you have the following prerequisites:
Before using Power BI APIs, you need to register your application in the Azure portal to get the necessary credentials.
Before using API you need the following:
🔹To use API’s you must have tenantId, client_id, client_secret, groupId, reportId all credentials. To get all these credentials you need to follow the following steps-
1. Go to the overview section of Azure registered applications there you will get clientId and tenantId.
2. To get the client_secret you can navigate to the Certificates and Secrets section of the registered application and there you will get the client_secret key.
3. To get the groupId and reportId, go to the Power BI workspace and select the report that you want to show at the front end. There check the URL, you will get both groupId and reportId.
🔹After getting all credentials, go to your Power BI workspace and click on Manage Access. Here add the Azure registered application’s display name. If you will not add your Azure application there and try to use Power BI API then you will get permission issues.
To use Power Bi API you need an Authorization token which will be obtained from the following Microsoft login API:
API - https://login.microsoftonline.com/{tenantId}/oauth2/v2.0/token Type - POST Body - x-www-form-urlencoded grant_type = client_credentials client_id = XXXXXXXXXXXXXXXXXX client_secret = XXXXXXXXXXXXXXXXXXXXXXXXX scope = https://analysis.windows.net/powerbi/api/.default
Following API will return the datasetID and embeddedUrl which will be used in further API to get access token:
API - https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}
Type - GET
Headers - Authorization: Bearer + <Access token get from first api>This API will provide the access token to integrate the Power BI report at the front end.
API - https://api.powerbi.com/v1.0/myorg/GenerateToken
Type - POST
Headers - Authorization: Bearer + <Access token get from first api>
Content - Type: application/json
Body- {
"datasets": [
{
"id": <Datasetid get from api 2.2>
}
],
"reports": [
{
"id": <report Id get from api 2.2 url after reports>
}
]
}These above APIs will provide embeddedUrl, accessToken, and reportId which will be used at the front end to integrate Power BI reports.
Open your React.js project and install the Power BI client library using npm:
npm install powerbi-client-react powerbi-client
Create a new component in your React application to handle the embedding of Power BI reports:
import { PowerBIEmbed } from 'powerbi-client-react';
import { models } from 'powerbi-client';
const PowerBIReport = () => {
const embedConfig = {
type: 'report',
id: <reportId>,
embedUrl: <embedUrl>,
accessToken: <accessToken>,
tokenType: models.TokenType.Aad,
settings: {
panes: {
filters: {
expanded: false,
visible: false,
},
},
navContentPaneEnabled: false,
},
}
return (
<div style={{ height: '100vh', width: '100%' }}>
<PowerBIEmbed embedConfig={embedConfig} />
</div>
);
};
export default PowerBIReport;If you want to add filters to the report then you need tableName, columnName, and filter values. Here is the code to embed Power BI reports with a filter:
import { PowerBIEmbed } from 'powerbi-client-react';
import { models } from 'powerbi-client';
const PowerBIReport = () => {
const embedConfig = {
type: 'report',
id: <reportId>,
embedUrl: <embedUrl>,
accessToken: <accessToken>,
tokenType: models.TokenType.Aad,
filters: [
{
$schema: "https://powerbi.com/product/schema#basic",
target: {
table: <tableName>,
column: <columnName>,
},
operator: "In",
values: ["value1", "value2"],
filterType: models.FilterType.Basic,
requireSingleSelection: true
},
],
settings: {
panes: {
filters: {
expanded: false,
visible: false,
},
},
navContentPaneEnabled: false,
},
}
return (
<div style={{ height: '100vh', width: '100%' }}>
<PowerBIEmbed embedConfig={embedConfig} />
</div>
);
};
export default PowerBIReport;
Integrating Power BI with React.js applications opens up a world of opportunities for creating dynamic and data-driven user experiences. By leveraging Power BI APIs and the power-client-react library, you can easily embed interactive reports and dashboards, providing users with real-time insights. With the steps outlined in this guide, you are well on your way to mastering Power BI integration in React.js.
Whether you are developing applications for internal business users or external clients, embedding Power BI reports in your React applications can significantly enhance your data visualization capabilities, leading to more informed decision-making.
The team at Mindbowser was highly professional, patient, and collaborative throughout our engagement. They struck the right balance between offering guidance and taking direction, which made the development process smooth. Although our project wasn’t related to healthcare, we clearly benefited...
Founder, Texas Ranch Security
Mindbowser played a crucial role in helping us bring everything together into a unified, cohesive product. Their commitment to industry-standard coding practices made an enormous difference, allowing developers to seamlessly transition in and out of the project without any confusion....
CEO, MarketsAI
I'm thrilled to be partnering with Mindbowser on our journey with TravelRite. The collaboration has been exceptional, and I’m truly grateful for the dedication and expertise the team has brought to the development process. Their commitment to our mission is...
Founder & CEO, TravelRite
The Mindbowser team's professionalism consistently impressed me. Their commitment to quality shone through in every aspect of the project. They truly went the extra mile, ensuring they understood our needs perfectly and were always willing to invest the time to...
CTO, New Day Therapeutics
I collaborated with Mindbowser for several years on a complex SaaS platform project. They took over a partially completed project and successfully transformed it into a fully functional and robust platform. Throughout the entire process, the quality of their work...
President, E.B. Carlson
Mindbowser and team are professional, talented and very responsive. They got us through a challenging situation with our IOT product successfully. They will be our go to dev team going forward.
Founder, Cascada
Amazing team to work with. Very responsive and very skilled in both front and backend engineering. Looking forward to our next project together.
Co-Founder, Emerge
The team is great to work with. Very professional, on task, and efficient.
Founder, PeriopMD
I can not express enough how pleased we are with the whole team. From the first call and meeting, they took our vision and ran with it. Communication was easy and everyone was flexible to our schedule. I’m excited to...
Founder, Seeke
We had very close go live timeline and Mindbowser team got us live a month before.
CEO, BuyNow WorldWide
If you want a team of great developers, I recommend them for the next project.
Founder, Teach Reach
Mindbowser built both iOS and Android apps for Mindworks, that have stood the test of time. 5 years later they still function quite beautifully. Their team always met their objectives and I'm very happy with the end result. Thank you!
Founder, Mindworks
Mindbowser has delivered a much better quality product than our previous tech vendors. Our product is stable and passed Well Architected Framework Review from AWS.
CEO, PurpleAnt
I am happy to share that we got USD 10k in cloud credits courtesy of our friends at Mindbowser. Thank you Pravin and Ayush, this means a lot to us.
CTO, Shortlist
Mindbowser is one of the reasons that our app is successful. These guys have been a great team.
Founder & CEO, MangoMirror
Kudos for all your hard work and diligence on the Telehealth platform project. You made it possible.
CEO, ThriveHealth
Mindbowser helped us build an awesome iOS app to bring balance to people’s lives.
CEO, SMILINGMIND
They were a very responsive team! Extremely easy to communicate and work with!
Founder & CEO, TotTech
We’ve had very little-to-no hiccups at all—it’s been a really pleasurable experience.
Co-Founder, TEAM8s
Mindbowser was very helpful with explaining the development process and started quickly on the project.
Executive Director of Product Development, Innovation Lab
The greatest benefit we got from Mindbowser is the expertise. Their team has developed apps in all different industries with all types of social proofs.
Co-Founder, Vesica
Mindbowser is professional, efficient and thorough.
Consultant, XPRIZE
Very committed, they create beautiful apps and are very benevolent. They have brilliant Ideas.
Founder, S.T.A.R.S of Wellness
Mindbowser was great; they listened to us a lot and helped us hone in on the actual idea of the app. They had put together fantastic wireframes for us.
Co-Founder, Flat Earth
Ayush was responsive and paired me with the best team member possible, to complete my complex vision and project. Could not be happier.
Founder, Child Life On Call
The team from Mindbowser stayed on task, asked the right questions, and completed the required tasks in a timely fashion! Strong work team!
CEO, SDOH2Health LLC
Mindbowser was easy to work with and hit the ground running, immediately feeling like part of our team.
CEO, Stealth Startup
Mindbowser was an excellent partner in developing my fitness app. They were patient, attentive, & understood my business needs. The end product exceeded my expectations. Thrilled to share it globally.
Owner, Phalanx
Mindbowser's expertise in tech, process & mobile development made them our choice for our app. The team was dedicated to the process & delivered high-quality features on time. They also gave valuable industry advice. Highly recommend them for app development...
Co-Founder, Fox&Fork
