Understanding Data Modeling in Power BI: Joins, Relationships, and Schemas Explained.

Stephen Omengo — Tue, 07 Apr 2026 07:14:51 +0000

Data modeling is a critical step in building effective Power BI reports. It shows how data is structured, connected, and used to generate understanding. A well-designed model improves performance and ensures accuracy, while a poor one can lead to slow dashboards and incorrect results.
This article explains data modeling in Power BI, covering SQL joins, relationships, schemas, and how to implement each step in practice.

Data Modeling

Data modeling is the process of organizing data into tables and showing how those tables relate to one another. This happens after data is imported and transformed.
Purpose of data modelling:

Efficient calculations
Structure of data
improve efficiency and clarity

SQL joins

What are joins? They are used to combine rows from two or more tables based on a related column.

1.Inner join

Returns only matching rows from both tables.

2.LEFT JOIN (LEFT OUTER)

Returns all rows from the left table and matching rows from the right.

3.RIGHT JOIN (RIGHT OUTER)

Returns all rows from the right table and matching rows from the left.

4.FULL OUTER JOIN

Returns all rows from both tables.

6. LEFT ANTI JOIN

Returns rows from the left table with no match in the right.

7.RIGHT ANTI JOIN

Returns rows from the right table with no match in the left.

How to Create Joins in Power BI
.Open Power BI Desktop
.Click Transform Data
.Select a table
.Click Merge Queries
.Select the second table
.Choose a matching column
Select join type:
.Inner
.Left Outer
.Right Outer
.Full Outer
.Left Anti
.Right Anti
Click OK
.Expand merged columns

Relationships in Power BI

Type of relationships:
1.One-to-Many (1) -Most common type.
2.Many-to-Many (M) -Both tables contain duplicate values.
3.One-to-One (1:1) -Each record matches exactly one record in another table.

Creating relationships in Power BI

.Go to Home → Manage Relationships
.Click New
.Select tables and columns
.Set cardinality and filter direction
.Click OK

Conclusion

Data modeling in Power BI is the foundation of effective reporting. Understanding joins, relationships, and schemas allows you to build models that are both efficient and reliable.

Guide to Publishing and Embedding Power BI Reports on the Web with IFrames

Stephen Omengo — Tue, 07 Apr 2026 07:13:36 +0000

Introduction

In today’s data-driven world, organizations rely heavily on tools that transform raw data into valuable insights. One of the most powerful solutions for this purpose is Microsoft Power BI. It enables analysts and businesses to create interactive dashboards and reports that support informed decision-making. One of the most powerful tools for this purpose is Microsoft Power BI. It allows analysts and businesses to create interactive dashboards and reports to support decision-making.

This article provides a step-by-step guide on how to :

Create a Power BI workspace
Upload and publish a report
Generate an Embed code
Embed the report into a website using an iframe

What is Power BI? This is a business analytics tool developed by Microsoft that enables users to transform, clean data, build interactive visualizations, and connect to multiple data sources*Excel*.

What is Power BI Publishing? Publishing a Power BI report involves moving your report from Power BI Desktop to the Power BI Service cloud platform.

Prerequisites

Key things to consider before you start:

Power BI Desktop installed
A Power BI account
A complete report

Step 1: Create a Workspace in Power BI Service

A workspace is a shared environment where you store datasets, reports, and dashboards.

Tutorial

Go to Power BI Service: https://app.powerbi.com
Log in using your account
On the left sidebar, click Workspaces
Click + New workspace
Enter: .Workspace name .Description
Click Save

Step 2: Prepare Your Report

You should make sure that your report is: Clean and well-structured, has meaningful visuals, uses proper relationships, and DAX measures.

Step 3: Publish the Report to Power BI Service

Tutorial

Open your report in Power BI

Click File → Publish → Publish to Power BI
Sign in if prompted
Select your workspace created earlier
Click Select

Once uploaded, you’ll see a confirmation message.

Step 4: Verify the Report in Power BI Service

Head back to Power BI Service
Open your workspace
Locate your report under Reports
Click to open and confirm everything is working

Step 5: Generate the Embed Code

Power BI allows you to embed reports using Publish to Web or secure embedding.
Note: Publishing to the web makes it easily accessible, and anyone with the link can view it.

Tutorial

Open your report in Power BI Service
Click File → Embed report → Publish to web

Click Create embed code

Confirm the warning
Copy the generated iframe code

Step 6: Understanding the IFrame Code

The embed code will look like this:
<iframe width="800" height="600" src="https://app.powerbi.com/view?r=..." frameborder="0" allowFullScreen="true"></iframe>

Key Attributes:
.Width & height: Control size
.Src: Contains report URL
.Frameborder: Removes border
.AllowFullScreen: Enables full-screen mode

Step 7: Embed the Report into a Website

.You can embed this iframe into:

HTML websites
Blogs (Dev.to, Medium)
Web apps

Step 8: Test Your Embedded Report

After embedding:
.Open your website in a browser
. Check: Report loads correctly, Filters and visuals work, and Responsiveness.

conclusion

Publishing and embedding Power BI reports is an essential skill for any data analyst. It allows you to transform your work into a shareable and interactive experience accessible from anywhere.

DEV Community: Stephen Omengo

Understanding Data Modeling in Power BI: Joins, Relationships, and Schemas Explained.

Data Modeling

SQL joins

1.Inner join

2.LEFT JOIN (LEFT OUTER)

3.RIGHT JOIN (RIGHT OUTER)

4.FULL OUTER JOIN

6. LEFT ANTI JOIN

7.RIGHT ANTI JOIN

Relationships in Power BI

Creating relationships in Power BI

Conclusion

Guide to Publishing and Embedding Power BI Reports on the Web with IFrames

Introduction

Prerequisites

Step 1: Create a Workspace in Power BI Service

Tutorial

Step 2: Prepare Your Report

Step 3: Publish the Report to Power BI Service

Tutorial

Step 4: Verify the Report in Power BI Service

Step 5: Generate the Embed Code

Tutorial

Step 6: Understanding the IFrame Code

Step 7: Embed the Report into a Website

Step 8: Test Your Embedded Report

conclusion