Feb 23, 2023
Power BI Embedded is a powerful tool that allows you to embed interactive Power BI reports and visualizations into your own applications. In this blog post, we will discuss the process of creating an application with Power BI Embedded and provide a code example to help you get started.
Before you can create an application with Power BI Embedded, you will need to have a Power BI Pro or Premium account. Once you have an account, you can create a new workspace and start building your report.
Once your report is complete, you can then create an application with Power BI Embedded by following these steps:
Register an application: To use Power BI Embedded, you will first need to register your application in the Azure portal. This will give you an Application ID that you can use to authenticate your application with Power BI.
Authenticate the user: Next, you will need to authenticate the user who will be accessing the report. This can be done using the Azure Active Directory Authentication Library (ADAL) for .NET or the Microsoft Authentication Library (MSAL) for JavaScript.
Embed the report: Once the user is authenticated, you can then embed the report into your application. This can be done by using the Power BI JavaScript library to create an iframe that displays the report.
Here is an example of how to embed a Power BI report into a web application using JavaScript:
<!DOCTYPE html>
<html>
<head>
<script src="https://ajax.aspnetcdn.com/ajax/jquery/jquery-3.5.1.min.js"></script>
<script src="https://microsoft.github.io/PowerBI-JavaScript/demo/node_modules/powerbi-client/dist/powerbi.js"></script>
</head>
<body>
<div id="reportContainer"></div>
<script>
//Authenticate the user and get an access token
var accessToken ="your_access_token";
//Get the report ID
var reportId ="your_report_id";
//Get the embed URL
var embedUrl ="https://app.powerbi.com/reportEmbed?reportId=" + reportId;
//Get the report container
var reportContainer =document.getElementById("reportContainer");
//Get the models
var models =window['powerbi-client'].models;
//Embed the report
var report =powerbi.embed(reportContainer, embedUrl,{
accessToken: accessToken,
settings: {
filterPaneEnabled: true,
navContentPaneEnabled: true
}
});
</script>
</body>
</html>
In this example, we first include the jQuery and Power BI JavaScript libraries. We then create a div element with the ID “reportContainer” that will be used to display the report. The code then authenticates the user and gets an access token. The report ID and embed URL are also specified. Finally, the report is embedded in the “reportContainer” div using the powerbi.embed() function.
Yes, it is also possible to create an application with Power BI Embedded using Python. Here is an example of how to embed a Power BI report into a web application using Python:
from flask import Flask, render_template
frompowerbiembedded import PowerBIAuth, PowerBI
app = Flask(__name__)
# Authenticate the user and get an access token
auth =PowerBIAuth("client_id", "client_secret")
access_token =auth.get_access_token()
# Get the report ID
report_id ="your_report_id"
# Create a Power BI object
powerbi =PowerBI(access_token)
# Embed the report
embed_url =powerbi.get_report_embed_url(workspace_id=None, report_id=report_id)
@app.route("/")
defindex():
returnrender_template("index.html", embed_url=embed_url)
if __name__ == "__main__":
app.run()
As you can see in this example, the process of embedding a Power BI report into a Python application is similar to the JavaScript example, you just need to use a python library to handle authentication and getting the embed url, and the rest of the process is almost the same.
Power BI Embedded can also be integrated into a Python application using the powerbiembedded library and some basic knowledge of Flask and JavaScript.
In conclusion, Power BI Embedded is a powerful tool that allows you to embed interactive Power BI reports and visualizations into your own applications. With a Power BI Pro or Premium account and some basic knowledge of JavaScript, you can create an application with Power BI Embedded and start taking advantage of the powerful data visualization capabilities
