DEV Community: Tom Chege

How to publish a Power BI report and embed it into a website

Tom Chege — Sun, 05 Apr 2026 09:43:14 +0000

Introduction

Power BI is a tool used for data cleaning, analysis, and presentation. Once you build your report locally, the next step is making it accessible to others.

In this guide, I will walk you through the process step by step. The end goal is to generate a shareable dashboard that can be viewed in a browser using an embedded iframe.

Items Needed

Your organization’s Power BI credentials: https://app.powerbi.com
A completed dashboard report available locally on your machine
A text editor such as VS Code or Sublime

Once you have the above, you can follow through the process to completion.

Step 1: Open Your Dashboard Report

Open your Power BI report on your local machine.

Click on Sign in on the far right of the screen as shown in the image below.

Step 2: Sign In to Power BI

Proceed and provide the necessary credentials.

Note: Power BI Service requires an organization email. Personal emails such as Gmail will not work.

Once successful, your account will appear on the top right.

Step 3: Select or Create a Workspace

On the left navigation bar in the Power BI Service:

Click on Workspaces
Either:
- Create a new workspace, or
- Use an existing one provided by your organization

Workspaces are where your reports are stored after publishing.

Step 4: Publish the Report

On Power BI Desktop:

Click Publish on the top navigation
Choose your workspace
Select from the dropdown or search for it

Step 5: Confirm Publishing

Once the workspace is selected, proceed to publish.

You will receive a confirmation screen with a link indicating that the report has been successfully published.

Step 6: Generate the Embed Code

Go to the Power BI Service in your browser:

Refresh your workspace
Open the report you just uploaded
Click File → Embed report

You will see the following options:

SharePoint Online
Website or portal
Publish to web (public)
Developer playground

For this tutorial, select Website or portal.

Copy the iFrame code that is generated.

Step 7: Create an HTML File

Open your text editor and create a new file such as index.html.

You can use a basic HTML boilerplate such as the one from:

https://www.w3schools.com/html/default.asp

Example:

<!DOCTYPE html>
<html>
<head>
<title>Sample Dashboard</title>
</head>
<body>

<h1>My First Power BI Dashboard Website</h1>

<iframe title="Kenya crop data" width="1140" height="541.25" src=
"https://app.powerbi.com/reportEmbed?reportId=YOUR EMBEDDED LINK" 
frameborder="0" allowFullScreen="true"></iframe>

</body>
</html>

Paste your copied iFrame into the HTML file.

Step 8: Open and Test

Save the file.

Right-click on index.html and open it with your browser.

It should render a page similar to the image below:

You may be prompted to sign in to Power BI to access the dashboard.

Conclusion

You have successfully:

Published a Power BI report to the cloud
Generated an embedded link
Displayed the report in a web page using an iFrame

This approach allows you to share dashboards in a more interactive and accessible way.

Notes

Users will need Power BI access to view the embedded report
For public sharing, Publish to web can be used, but this should be handled carefully since it exposes your data
Ensure the right workspace permissions are set if other users cannot access the report

Congratulations — you have now built and shared your first embedded Power BI dashboard.

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

Tom Chege — Sun, 29 Mar 2026 18:10:19 +0000

Introduction

Working with raw data often introduces challenges such as duplication, inconsistency, and difficulty in extracting meaningful insights.

Data modelling in Power BI addresses these challenges by structuring data into related tables, enabling efficient querying, accurate calculations, and scalable reporting.

This article explores:

SQL joins and their behaviour
Power BI relationships and how they differ from joins
Data modelling schemas
Practical implementation in Power BI

We’ll use a simple school dataset to ground these concepts.

1. Sample Dataset

We will work with three core tables:

Students (Dimension Table)

StudentID	Name	Age	Class
101	Alice	14	Form 2
102	Brian	15	Form 3
103	Catherine	14	Form 2
104	David	16	Form 4

Test Scores (Fact Table)

ScoreID	StudentID	Subject	Score
1	101	Math	85
2	101	English	78
3	102	Math	92
4	105	Science	88

⚠️ Note: Student 105 does not exist in the Students table—this represents a referential integrity issue.

📊 View Dataset Online

Explore the dataset directly: 👉here!

Teachers (Dimension Table)

TeacherID	Name	Subject
T1	Mr. Kim	Math
T2	Ms. Asha	English
T3	Mr. Otieno	Science

Data Roles

Fact Table: Test Scores (transactional/measurable data)
Dimension Tables: Students, Teachers (descriptive attributes)

2. What is Data Modelling?

Data modelling is the process of:

Organizing data into structured tables and defining relationships that enable efficient querying and accurate analysis.

In analytical systems like Power BI, this typically involves:

Separating facts from dimensions
Establishing keys (e.g., StudentID)
Designing a schema optimized for performance

3. Joins vs Relationships

Joins (Power Query Layer)

A join is a data transformation operation that combines rows from two or more tables based on a matching condition.

Key Characteristics:

Produces a new table
Data is physically merged
Can introduce duplication

Example:

Joining Students and Test Scores results in repeated student records for each score.

Relationships (Model Layer)

A relationship is a logical link between tables based on matching columns.

Key Characteristics:

Tables remain separate
Data is combined at query time
Enables efficient filtering and aggregation via DAX

Critical Difference

Aspect	Join	Relationship
Type	Physical transformation	Logical connection
Location	Power Query	Model View
Data duplication	Yes	No
Performance impact	Higher memory usage	Optimized

4. SQL Joins Explained (with Examples)

Joins determine how rows from two tables are combined based on a matching condition.

We will use:

Students table (left table)
Test Scores table (right table)

INNER JOIN

Definition

Returns only rows where a match exists in both tables.

SQL Example

SELECT s.StudentID, s.Name, t.Subject, t.Score
FROM Students s
INNER JOIN TestScores t
ON s.StudentID = t.StudentID;

Result

StudentID	Name	Subject	Score
101	Alice	Math	85
101	Alice	English	78
102	Brian	Math	92

Explanation

Student 103 and 104 are excluded (no scores)
Score with StudentID 105 is excluded (no matching student)

LEFT JOIN

Definition

Returns all rows from the left table, with matching rows from the right.

SQL Example

SELECT s.StudentID, s.Name, t.Subject, t.Score
FROM Students s
LEFT JOIN TestScores t
ON s.StudentID = t.StudentID;

Result

StudentID	Name	Subject	Score
101	Alice	Math	85
101	Alice	English	78
102	Brian	Math	92
103	Catherine	NULL	NULL
104	David	NULL	NULL

Explanation

All students are included
Missing scores appear as NULL
Useful for identifying missing activity

RIGHT JOIN

Definition

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

SQL Example

SELECT s.StudentID, s.Name, t.Subject, t.Score
FROM Students s
RIGHT JOIN TestScores t
ON s.StudentID = t.StudentID;

Result

StudentID	Name	Subject	Score
101	Alice	Math	85
101	Alice	English	78
102	Brian	Math	92
NULL	NULL	Science	88

Explanation

Score for StudentID 105 appears
Missing student info is NULL
Highlights data inconsistencies

FULL OUTER JOIN

Definition

Returns all rows from both tables, matched where possible.

SQL Example

SELECT s.StudentID, s.Name, t.Subject, t.Score
FROM Students s
FULL OUTER JOIN TestScores t
ON s.StudentID = t.StudentID;

Result

StudentID	Name	Subject	Score
101	Alice	Math	85
101	Alice	English	78
102	Brian	Math	92
103	Catherine	NULL	NULL
104	David	NULL	NULL
NULL	NULL	Science	88

Explanation

Combines LEFT and RIGHT JOIN behavior
Shows all matched and unmatched records

LEFT ANTI JOIN

Definition

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

SQL Equivalent

SELECT s.StudentID, s.Name
FROM Students s
LEFT JOIN TestScores t
ON s.StudentID = t.StudentID
WHERE t.StudentID IS NULL;

Result

StudentID	Name
103	Catherine
104	David

Explanation

These students have no test scores
Useful for identifying inactivity

RIGHT ANTI JOIN

Definition

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

SQL Equivalent

SELECT t.StudentID, t.Subject
FROM TestScores t
LEFT JOIN Students s
ON s.StudentID = t.StudentID
WHERE s.StudentID IS NULL;

Result

StudentID	Subject
105	Science

Explanation

This score has no valid student
Indicates a data quality issue

Key Insight

Each join answers a specific business question:

Join Type	Business Question	Example from Our Dataset
INNER	What data exists in both tables?	Which students have recorded test scores? → Alice and Brian
LEFT	What records are missing related data?	Which students are in the system but have not taken any tests? → Catherine and David
RIGHT	What data exists on the secondary side?	Are there any test scores without valid student records? → Score for StudentID 105
FULL	What does the complete dataset look like?	What is the full picture of students and scores, including missing or unmatched data?
LEFT ANTI	What records in the main table have no matches?	Which students have no test scores at all? → Catherine and David
RIGHT ANTI	What records are invalid or inconsistent?	Which test scores do not belong to any student? → StudentID 105

5. Power BI Relationships

Cardinality

Defines how rows relate between tables.

Type	Description
1:M	One dimension record relates to many fact records
M:M	Multiple matches on both sides
1:1	Unique mapping

👉 Best practice:
Use 1:M from Dimension → Fact

Cross-Filter Direction

Defines how filters propagate between tables.

Type	Behaviour
Single	One-way filtering
Both	Bi-directional filtering

⚠️ Overusing bi-directional filtering can introduce ambiguity.

Active vs Inactive Relationships

Only one relationship can be active between two tables
Inactive relationships can be used via DAX (USERELATIONSHIP)

6. Fact vs Dimension Tables

Fact Table

Contains measurable data
Often large
Example: Test Scores

Dimension Table

Contains descriptive attributes
Used for filtering and grouping
Example: Students

7. Schemas

Star Schema

          Students
             |
Teachers — Test Scores — Subjects

Characteristics:

Central fact table
Denormalized dimensions
Optimized for performance

Snowflake Schema

Students
   |
Address
   |
Region
   |
Test Scores

Characteristics:

Normalized dimensions
Reduced redundancy
Increased complexity

Flat Table (Denormalized Model)

All data stored in one table.

Trade-offs:

Simpler structure
Poor scalability
High duplication

8. Implementation in Power BI

Power Query (Data Preparation)

Clean data
Perform joins
Handle missing values

Model View (Data Modelling)

Create relationships
Define cardinality
Configure filters

Best Practice Workflow

Load data
Clean in Power Query
Avoid unnecessary joins
Build relationships in Model View
Validate using visuals

9. Common Modelling Issues

Data duplication from excessive joins
Incorrect cardinality
Ambiguous filter paths
Missing or inconsistent keys

Conclusion and Key Takeaways

Data modelling is the foundation of effective analysis in Power BI. It defines how data is structured, interpreted, and ultimately how insights are derived.

Throughout this article, we’ve seen how:

Joins are used to reshape and prepare data by combining tables in Power Query
Relationships allow Power BI to connect tables logically, enabling efficient analysis without duplication
Schemas, particularly the star schema, provide a scalable structure for organizing fact and dimension tables
Data integrity (e.g., handling missing or invalid records like StudentID 105) directly impacts the quality of insights

Practical Takeaways

Use Power Query for data cleaning and controlled joins
Use Model View to define relationships and control how data interacts
Prefer 1:M relationships from dimension to fact tables
Default to single-direction filtering unless there is a clear need for bi-directional filtering
Adopt a star schema for most analytical scenarios
Treat missing or unmatched data as valuable signals, not just errors

How Excel is Used in Real-World Data Analysis

Tom Chege — Tue, 24 Mar 2026 06:13:39 +0000

Working with real-world data is rarely clean. Unlike textbook examples, datasets often contain inconsistencies like text mixed with numbers, duplicate values, missing fields, and ambiguous identifiers.

Over the past week, I’ve been exploring key Excel concepts such as error handling, aggregation, lookup functions, and data cleaning. Each of these plays a critical role in transforming raw, messy data into reliable insights.

In this article, I’ll focus specifically on error handling which is a foundational skill that helps ensure your formulas remain robust even when your data isn’t.

What are Excel errors and why do they matter?

Excel errors are often seen as problems to eliminate, but they are actually signals. Each error tells you something specific about your data or logic:

#DIV/0! → You’re dividing by zero or an empty cell
#N/A → A lookup couldn’t find a match
#VALUE! → The data type is incorrect (e.g., text instead of a number)
#NAME? → Excel doesn’t recognize part of your formula

Ignoring these errors or masking them without understanding their cause can lead to misleading results. Instead, they should be treated as indicators of underlying data issues.

The role of IFERROR

One of the most commonly used tools for handling errors in Excel is the IFERROR function. It allows you to return an alternative result when a formula fails.

Example:

=IFERROR(Bonus/Salary, 0)

This ensures that if Salary is missing or zero, the formula does not break but instead returns 0.

⚠️ While this improves usability, it introduces a new responsibility: ensuring that the fall back value does not distort the meaning of your analysis.

The risk of hiding errors

A common mistake is using IFERROR to suppress errors without considering their implications.

=IFERROR(Salary * 0.1, 0)

If Salary is missing, this formula returns 0, which may incorrectly suggest that the calculated value is genuinely zero.

A more transparent approach would be:

=IF(ISBLANK(Salary), "Missing Salary", Salary * 0.1)

This makes the issue visible and preserves the integrity of your data.

Handling specific errors more intelligently

Not all errors should be treated the same. In many cases, it is better to target specific error types.

For example, when working with lookups:

=IF(ISNA(VLOOKUP(A2, A:B, 2, FALSE)), "Not Found", VLOOKUP(A2, A:B, 2, FALSE))

This distinguishes between a missing value (#N/A) and other potential issues, allowing for more precise handling.

Combining logic and error handling

Robust formulas often combine conditional logic with error handling to cover multiple scenarios.

=IFERROR(
  IF(ISBLANK(A2), "No Input", XLOOKUP(A2, A:A, B:B)),
  "Not Found"
)

This structure:

Checks for empty input -- ISBLANK
Performs a lookup when valid -- XLOOKUP
Returns a clear message if the lookup fails -- "No Input"

Such layered logic makes your formulas more resilient and easier to interpret.

What I have learnt about error handling

Treat errors as signals, not just problems
Avoid blindly replacing errors with default/placeholder values
Use targeted checks such as ISNA or ISBLANK where appropriate
Ensure default/placeholder values do not distort analysis
Design formulas with real-world data imperfections in mind

Final takeaway:

Errors are feedback. By understanding the types of errors, applying functions like IFERROR thoughtfully, and combining them with logical checks, you can build Excel models that are both reliable and transparent.

Creating a windows server VM on Azure

Tom Chege — Thu, 19 Mar 2026 06:51:07 +0000

Some problems in software are complex and then there are the other peculiar problems.

The ones that appear simple until they quietly refuse to cooperate.

Recently, I needed to spin up a virtual machine on Microsoft Azure. Nothing fancy. Just a small server running Windows Server 2025 Datacenter for a bit of experimentation.

In theory, creating a VM in the cloud should be one of the most straightforward tasks in modern computing. Click a few buttons, choose an operating system, wait a moment, and somewhere in a distant datacenter a machine materializes.

Reality, as it often does, had a slightly different plan.

The deployment failed with a message that looked innocuous but carried just enough ambiguity to slow things down:

The selected image is not valid for the specified location.

At first glance, it reads like a configuration mistake. Choose a different option and try again. But cloud systems rarely fail randomly; they fail for reasons that are usually hidden one layer deeper than the interface suggests.

In this case, the issue was geographical. I discovered this after tinkering with various images and location settings.

Azure operates dozens of data centers across the world. Each region has slightly different hardware, capacity, and image availability. When you select an operating system image, you are implicitly asking a very physical question: Does this datacenter actually have that image available right now?

Sometimes the answer is no.

Once that realization clicks, the error message suddenly makes perfect sense.

With that small puzzle resolved, I thought it would be useful to write down the exact process for creating a VM in Azure. If nothing else, it may spare someone else a few minutes of head scratching.

Creating a Virtual Machine in Azure

The starting point is the Azure portal.

Open the dashboard and log in:

https://portal.azure.com

This interface is essentially the command center for everything running on Microsoft’s cloud infrastructure.

Once inside, use the search bar and type Virtual Machines. Select the service and click:

Create → Azure Virtual Machine

That opens the configuration wizard where the real work begins.

Basic Configuration

The first section defines the environment where the VM will live.

Start by creating or selecting a resource group. Resource groups act as containers that hold related infrastructure components.

Example:

vm-lab-rg

Next, give the machine a name:

my-first-vm

Naming may seem trivial, but good naming conventions save time later when environments grow larger.

Choosing the Right Region

Azure requires you to pick a geographic region where the VM will run.

Some commonly reliable regions include:

West Europe
UK South
UAE North

The region choice affects latency, pricing, and as I learned sometimes which operating system images are available.

Selecting the Operating System

This is the step where many deployments quietly succeed or fail.

A widely compatible option is:

Windows Server 2025 Datacenter: Azure Edition – x64 Gen2

This image integrates well with Azure’s virtualization environment and is generally available across most regions.

Choosing a VM Size

Next comes the machine size. In cloud terms, this defines CPU power, memory, and cost.

For experimentation or lightweight workloads, something modest works well.

Choosing a VM size is essentially selecting how powerful you want your rented computer to be.

Administrator Credentials

Azure then asks you to create an administrator account for the machine.

Example:

Username: azureadmin
Password: ********

If you are creating a Windows machine, enable the option that allows Remote Desktop (RDP) access. This allows you to connect to the server after deployment.

Storage and Networking

For most use cases, the default settings here work perfectly well.

Azure automatically provisions:

a virtual network
a subnet
a public IP address
a network security rule for RDP

For storage, the default Standard SSD disk is usually a good balance between performance and cost.

Deployment

With the configuration complete, click Review + Create.

Azure validates the settings and then begins the deployment process.

Within a couple of minutes the platform allocates compute resources, attaches storage, configures networking, and boots the virtual machine.

Connecting to the Machine

Once the deployment completes, the next step is actually getting into the server.

Azure provides a few connection options through the portal, but the simplest approach is to connect using Microsoft Remote Desktop.

After the VM is created, Azure automatically assigns a public IP address to the machine. You can find it in the VM’s overview page inside Microsoft Azure.

In my case, I simply copied that public IP and opened a connection through the Microsoft Remote Desktop client.

The process looks roughly like this:

Host: <public-ip-address>

When prompted, enter the administrator credentials you created during the VM setup.

Username: azureadmin
Password: ********

If everything is configured correctly and the RDP port was allowed during deployment the connection should establish within a few seconds.

At that point, you are no longer looking at the Azure portal. You are looking at the desktop of a Windows machine running somewhere inside Microsoft’s global datacenter network.

Yet there it is, responding to your keyboard and mouse as if it were sitting right in front of you.

A Small Reflection

Cloud computing often feels magical. Servers appear and disappear on command. Storage scales endlessly. Networks stretch across continents.

But every now and then the illusion cracks just enough to remind you what is happening underneath.

And sometimes, all it takes to see that reality is a small error message about a missing image in chosen location.