Skip to main content

Interested in learning how to create a custom .NET MVC App? You've come to the right place! 

Note: This blog is meant for a technical audience. An executive-focused article on Power BI Embedded can be found here.

For this blog, we'll be focused on the Power BI Embedded A-Series (Azure) SKU, and we'll be using the "App Owns Data" model, which is the model that allows you to embed Power BI reports for your customers. More information on this model can be found here.


Requirements

  • An Azure Active Directory tenant (if you'd like to set up a full production environment), or a regular Power BI Pro account (can be used to set up a test environment)
  •  
  • Visual Studio - Free Community version is available here
  •  
  • Business Intelligence Workshop

Set up your Power BI Embedding Environment

To set up your Power BI embedding environment, go to: https://app.powerbi.com/embedsetup/AppOwnsData. Then run through the steps as described below:

Step 1 - Sign in to Power BI

i. Sign in with an account used for the Power BI service.

Set up your Power BI Embedding Environment

ii. Click Next

Set up your Power BI Embedding Environment

 

Step 2 - Register Application

i. First enter the name of the application.

ii. Next, select the access permissions. For the purposes of this series, we only need to read reports, so we'll limit our access to just that.

iii. Finally, click "Register"

How to Set up your Power BI Embedding Environment

 

Step 3 - Create the Power BI App Workspace

i. First enter the name of the app workspace.

ii. Click "Create app workspace"

Set up your Power BI Embedding Environment

 

Step 4 - Upload a sample Power BI Report

i. Download this .pbix file that we'll use for this series of articles

ii. Select "Upload .pbix file"

iii. Browse to the location where you saved the .pbix file

iiii. Click "Import"

Import content Power BI Embedding Environment

 

Step 5 - Grant Permissions

i. Click "Grant Permissions"

Grant Permissions on Power BI Embedding Environment

ii. A pop-up window will appear, click "Accept"

Permission Requested Power BI Embedding Environment

 

Step 6 - Download Sample App

i. Click "Download sample app"

Power BI Embedding Environment

 

Step 7 - Extract Sample App

i. Click on the downloaded .zip file

ii. Click Extract to unzip it

Extract Sample App Power BI Embedding Environment

 

Step 8 - Open Solution and Enter Password into Web.config

i. Open up the extracted Visual Studio solution file into Visual Studio

ii. Click on the Web.config file

iii. Enter the password for the account used to sign into Power BI

 

Web.config Power BI Embedding Environment

 

Step 9 - Run Solution and Embed Report

i. Click on the Run button in Visual Studio

Run Solution Power BI Embedding Environment

ii. Click on "Embed Report" in the browser window

Embed Report Power BI Embedding Environment

If all goes well, you should now have a report embedded into a custom .NET MVC web application running on the localhost of your computer like in the image below:

Embedded Report Power BI Embedding Environment

Related:

Power BI Usage Metrics Across All Workspaces: Step by Step

Power BI TopN and Other

 


  • What Power BI is capable of & How Power BI can be 

  • used to aggregate your data:

Learn More about Power BI


Get Started with MS Power BI Today

There are so many things MS Power BI can do to increase data visibility and improve decision making within your organization. So, let’s recap a few important points about why you need MS Power BI in your organization.

MS Power BI is data import, modeling, and visualization made easier. It can be a self-service data visualization tool for your end-users, or we can help build reports and dashboards for you. MS Power BI has desktop and mobile clients - even for Apple Watch - along with web-based dashboards and reports, making your data and KPIs easy to access from any device at any time.

Simply put, MS Power BI is an extremely versatile Business Intelligence platform. If you want to learn more about how to take full advantage of MS Power BI, drop us a line today. Our team of Data & Analytics experts will be happy to schedule a demo or a tutorial session.

HIROC's Case Study

Scott Sugar
By Scott Sugar
March 26, 2021
From the 1980's, when his father used to hand down old computer equipment, to now, Scott Sugar has always had a fascination with technology. The ability to communicate with people, regardless of distance or location, is, in Scott's opinion, one of the best things about tech. With over 20 years of experience in the IT industry, and 17 years at ProServeIT, Scott's areas of expertise include data & analytics, and IT operations, monitoring, and alerting. Scott heads up ProServeIT's Ho Chi Minh City, Vietnam office. He has spent the majority of his adult life in Asia, and speaks 3 languages. 

Comments