Power BI Modelling Error

Power BI Modelling Error

The error message above indicates I have a null value but Power Query was unable to convert it into logical values. When a model doesn’t load, here is what to do

When you work with Power BI, you will inevitably experience something like this.

Image for post

Image by author

Those words. “Model doesn’t load” — just makes me… cringe.

If your model doesn’t load, it’s because a transformation have failed in Power Query.

If you need to see how to build a model, take a look at this article. Thank you everyone for reading it.

If you need a refresher on joins — here is article 1 and article 2. Yes, they contribute to errors too and they are more subtle, and much more costly.

Let’s explore some of these error messages.

Failure with one of the Tables.

In the image above, Power BI indicates it wants to load the model, but because of a “previous” table, it’s unable to load the model.

The error is described by the [Expression.Error] section and the table with this error is the one you will need to trouble shoot in Power Query.

[Expression.Error ]— Wrong data type.

The error message above indicates I have a null value but Power Query was unable to convert it into logical values.

Here is how to fix it and think about it

  1. Missing Values — if the column you are using needs to be converted to logical, ask why they are missing in the first place. In my case it was a data error at source. Missing values in your source highlight something is not right in your query.
  2. Remove Errors or Replace Errors. These options can be found by a right click on the column. The nulls or missing values for some reason didn’t load properly, but I know they were all suppose to be 0's so I’ve used
  3. Replace Errors and it loaded fine.

power-bi data-analysis data-visualization data-science technology

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Tableau vs Power BI: Comparing the Data Visualization Tools

In analytics, Tableau is the leading visualisation tool. Its rich analytical features and attention to data details are the reason behind its popularity. Power BI, on the other hand, is preferred by professionals who are more comfortable with...

Explore your JIRA Data with Power BI

JIRA Software provides bug tracking, issue tracking, and project management capabilities for teams and organizations. The JIRA content pack for Power BI helps you quickly import JIRA data so you can get an instant dashboard to analyze workloads...

Managing your Data with Microsoft’s Power BI

In a world where the sheer amount of data is often overwhelming, the ability to interrogate and organise data to make meaningful business decisions is more important than ever. Microsoft have created Power BI to enable every day users to use the...

Push Card visuals to a new level in Power BI

Push Card visuals to a new level in Power BI. Bring new life to traditional Power BI visuals and learn how to achieve expand/collapse functionality with a simple workaround

Exploratory Data Analysis is a significant part of Data Science

Data science is omnipresent to advanced statistical and machine learning methods. For whatever length of time that there is data to analyse, the need to investigate is obvious.