Introduction

Semantic Models in Power BI are most often used with Power BI Dashboards, but they're also available for application integration using custom applications. This post outlines a companion YouTube video walking through the process of integrating a React Web App with the Power BI REST API to directly query Semantic Models hosted in Microsoft Fabric.

Solution Architecture

Below is an illustration of the solution we'll develop in this tutorial.

Entra/React Application Integration

What's Covered

In the video, we'll cover the following topics:

  1. Adding Power BI API Permissions to an existing App Registration. This authorizes a web app to query Semantic Models using the end-user's access token.
  2. Fetch a Power BI/Fabric Access Token. Correct access tokens in the Authorization header is a key element of a successful integration.
  3. Add Semantic Model Query Code to a React App. This tutorial demonstrates the use of the Power BI REST API to query semantic models.
  4. Submit Queries and Display Results. Finally, we'll test the implementation by submitting a test query to a Fabric Workspace.

Video

Below is the embedded YouTube video of the full tutorial. If you're interested only in certain sections, bookmarks are provided to skip ahead (or back) to the specific video sections.

YouTube Video Link

Code on GitHub

Code developed for this post is available on GitHub:

GitHub - robkerr/azure-msal-react-tutorial: This repo contains tutorials showing how to integrate React with Entra and Fabric
This repo contains tutorials showing how to integrate React with Entra and Fabric - robkerr/azure-msal-react-tutorial