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 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.
Let’s explore some of these error messages.
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.
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
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...
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...
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. Bring new life to traditional Power BI visuals and learn how to achieve expand/collapse functionality with a simple workaround
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.