Select Page
In The Trenches

The Best Articles and Tutorials About Cloud Analytics, BI and Management 

Hi! I’m Paul. I’m a data nerd from the beautiful suburb of Durbanville, Cape Town.
I’m available for short term BI / data engineering projects and Cloud data migrations on Azure, AWS or Google Cloud.

To view my resume, please access it here:
Paul Hansen – Business Intelligence Professional 2023

Contact Me

Business Intelligence and Analytics Blog

Power Query allows you to merge (“join” in database terms) two tables together in a variety of different ways, including left and right anti joins. Unfortunately, as I found recently, anti joins don’t fold on SQL Server-related data sources, which can result in performance problems. Luckily there is a different way of doing anti joins […]

This post first appeared at https://blog.crossjoin.co.uk/2023/12/03/anti-joins-and-query-folding-in-power-query-in-excel-and-power-bi/. The author is Chris Webb

Read More

Read More

It’s true that you can create reports in Power BI Desktop for free. However, it’s not for sharing and consuming. If you want to share your work with others, especially end users, consider purchasing a paid license. This will give you a more robust and secure solution for data sharing and governance. But how much […]

This post first appeared at https://p3adaptive.com/how-much-does-power-bi-cost/. The author is Marketing

Read More

Read More

Learning Power BI at your own pace, in the comfort of your home, might just be what suits you best right now.  Sure, it can seem daunting to learn all by yourself. But don’t worry. You are never truly alone in your learning journey. As a leading Power BI consulting service, we’re here to guide […]

This post first appeared at https://p3adaptive.com/how-can-i-practice-power-bi-at-home/. The author is Marketing

Read More

Read More

Have you ever had a situation where you have a slicer selection that “sticks”? You make a selection in a slicer, then make some changes somewhere else, but the first selection you made “sticks” when it is no longer valid? Take a look at this animated demo below to see […]Read More » This post […]

This post first appeared at https://exceleratorbi.com.au/slicer-values-dont-clear-after-changing-a-second-slicer/. The author is Matt Allington

Read More

Read More

In November 2023 release we added a new fourth view in public preview to Power BI Desktop, the DAX query view! The DAX query view gives you the ability to write, edit, and see the results of Data Analysis Expressions or DAX queries on your semantic model. Finally, you can now take advantage of the […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/deep-dive-into-dax-query-view-and-writing-dax-queries/. The author is 

Read More

Read More

When comparing Microsoft Power BI vs. Tableau pros and cons, one aspect that distinctly sets them apart is their approach to data modeling. As Power BI Consulting experts, we believe that their data modeling capabilities are worth discussing. Let’s face it: the data model is like the brain of these tools. Want to know which […]

This post first appeared at https://p3adaptive.com/2023/11/what-is-the-difference-between-tableau-and-power-bi-data-model/. The author is Marketing

Read More

Read More

Power BI Tutorial

Nov 27, 2023

Power BI skills are hot right now. People want them. Companies need them. Learning it could be a game-changer for you. But how to start? Is it easy or hard? Can you learn it quickly by yourself? That’s exactly what this article is about. As a Power BI Consulting service, we’re here to support your […]

This post first appeared at https://p3adaptive.com/2023/11/power-bi-tutorial/. The author is Marketing

Read More

Read More

Power BI Online

Nov 27, 2023

Wondering if Power BI has an online version? Well, many people are asking the same question, and it’s time to put your curiosity to rest.  As a leading Power BI consulting service, we’ll give you the comprehensive explanation you need about the online version of Power BI. So, stay tuned as we’ll break down everything […]

This post first appeared at https://p3adaptive.com/2023/11/power-bi-online/. The author is Marketing

Read More

Read More

A lot of DAX performance problems relate to the use of strict and eager evaluation with the IF or SWITCH functions. It’s an incredibly complex, “it depends”, black-box type of topic and naturally Marco and Alberto have a great article on it here. Rather than describe any general rules – which would be pretty much […]

This post first appeared at https://blog.crossjoin.co.uk/2023/11/26/if-switch-and-the-effect-of-dax-variables-on-strict-eager-evaluation/. The author is Chris Webb

Read More

Read More

In this article I’m going to talk about the recent change that Microsoft has made in renaming the underlying database used in Power BI from the term “dataset” to “semantic model” (or as I would call it, “semantic data model”). The Word “Semantic” Let me start by talking about the […]Read More » This post […]

This post first appeared at https://exceleratorbi.com.au/why-did-microsoft-rename-datasets-to-semantic-models/. The author is Matt Allington

Read More

Read More

Last week it was announced that Power BI datasets have been renamed: they are now semantic models. You can read the announcement blog post here and see the change in the Fabric/Power BI UI already. The name change proved to be surprisingly uncontroversial. Of course it’s very disruptive – trust me, I know, I have […]

This post first appeared at https://blog.crossjoin.co.uk/2023/11/18/thoughts-on-power-bi-datasets-being-renamed-to-semantic-models/. The author is Chris Webb

Read More

Read More

Introducing reference labels: the new feature that will rock your new cards! Now you can add custom labels to your new cards that show amazing information and comparisons. This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-cards-reference-labels-public-preview/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-cards-reference-labels-public-preview/. The author is 

Read More

Read More

We’re excited to announce the latest addition to Power BI’s new slicer experience – the button slicer! Crafted with your feedback and participation in mind, this innovative tool offers unparalleled customization and ease of use. This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-slicer-button-public-preview/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-slicer-button-public-preview/. The author is 

Read More

Read More

Introducing the public preview of the new Explore feature, where users have a lightweight and focused experience to explore their data. Similar to exporting and building a PivotTable in Excel, now, directly within Power BI users can quickly launch Explore to begin creating a matrix/visual pair to get the answers they need without all the […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-explore-public-preview/. The author is 

Read More

Read More

We are thrilled to announce the general availability of Microsoft Fabric and the public preview of Copilot in Microsoft Fabric, including the experience for Power BI. With the launch of these next-generation analytics tools, you can empower your data teams to more easily scale to meet the demand of the business. You can create a […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/empower-power-bi-users-with-microsoft-fabric-and-copilot/. The author is 

Read More

Read More

Welcome to the November 2023 update. We’ve got a lot of great features this month including DAX Query view, Semantic Model Scale-out, and Advanced Filtering for Paginated Reports.  This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-november-2023-feature-summary/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-november-2023-feature-summary/. The author is 

Read More

Read More

Excel workbooks are one of the slowest data sources you can use with Power Query in Excel or Power BI. Reading small amounts of data from small workbooks is usually fast; reading large amounts of data from large workbooks can be very slow. But what about reading small amounts of data from large Excel workbooks? […]

This post first appeared at https://blog.crossjoin.co.uk/2023/11/12/excel-workbook-layout-and-the-performance-of-reading-data-with-power-query-in-power-bi/. The author is Chris Webb

Read More

Read More

The popularity of Microsoft Power BI has skyrocketed in recent years. The fact that more and more people use it can indicate its quality, reliability, and usability. Of course, affordability plays an important role. But it’s not the only reason why more and more people use Power BI. Power BI sets the standard for a […]

This post first appeared at https://p3adaptive.com/2023/11/why-is-power-bi-more-popular-than-tableau/. The author is Rob Collie

Read More

Read More

Tableau VS Power BI

Nov 11, 2023

The battle between Tableau and Power BI is always a hot topic. These two giants dominate the landscape, each boasting their own strengths. But which one is best for your business needs? Is Tableau a true Power BI alternative? As a Power BI Consulting expert, we bring you the most relevant and latest information to […]

This post first appeared at https://p3adaptive.com/2023/11/tableau-vs-power-bi/. The author is Rob Collie

Read More

Read More

Datasets are being renamed to semantic models in Power BI and Fabric. This will make the product clearer and more usable and reflects the immense progress that Power BI datasets have made in becoming an enterprise-grade semantic modeling technology. The semantic model name will help drive awareness of the unparalleled capabilities provided. This post first […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/datasets-renamed-to-semantic-models/. The author is 

Read More

Read More