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

Announcing the deprecation of creation of machine learning models in Power BI using Dataflows V1 This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-deprecation-of-creation-of-machine-learning-models-in-power-bi-using-dataflows-v1/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-deprecation-of-creation-of-machine-learning-models-in-power-bi-using-dataflows-v1/. The author is 

Read More

Read More

Copilot for Power BI has new capabilities in Public Preview! Users in view mode can now ask about insights, summaries, trends, and data questions and receive natural language responses, making analysis easier than ever. This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-copilot-for-power-bi-chat-based-capabilities-summarize-inquire-analyze/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-copilot-for-power-bi-chat-based-capabilities-summarize-inquire-analyze/. The author is 

Read More

Read More

We recently made the following Power BI app improvements you asked for: the ability to copy item links from authoring view, a setting for granting access to hidden content, and increasing the maximum number of audiences to 25 (previously 10). This post first appeared at https://powerbi.microsoft.com/en-us/blog/improvements-to-power-bi-apps-an-increase-in-audiences-and-access-control-for-hidden-content/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/improvements-to-power-bi-apps-an-increase-in-audiences-and-access-control-for-hidden-content/. The author is 

Read More

Read More

Hybrid tables – tables which contain both Import mode and DirectQuery mode partitions to hold data from different time periods – have been around for a while. They are useful in cases where your historic data doesn’t change but your most recent data changes very frequently and you need to reflect those changes in your […]

This post first appeared at https://blog.crossjoin.co.uk/2024/02/25/datacoveragedefinition-a-new-optimisation-for-hybrid-tables-in-power-bi/. The author is Chris Webb

Read More

Read More

In today’s data-driven business environment, Microsoft Fabric Data Analytics is emerging as a crucial tool for organizations aiming to enhance their data management and analytics capabilities. It integrates seamlessly with other Microsoft services, including Power BI, offering a robust platform for data tasks ranging from simple management to complex analytics. This guide is designed to […]

This post first appeared at https://p3adaptive.com/how-do-i-activate-microsoft-fabric/. The author is Marketing

Read More

Read More

As Microsoft debuted its new Microsoft Fabric Data Analytics platform in 2023, promising enhanced data unification, you may wonder how it fits into the existing Azure Synapse architecture. With overlapping data engineering, warehousing, and analytics capabilities, could Microsoft Fabric phase out the need for complex PaaS solutions like Azure Synapse? Or do the tools play […]

This post first appeared at https://p3adaptive.com/does-microsoft-fabric-replace-azure-synapse/. The author is Marketing

Read More

Read More

In the ever-evolving landscape of data analytics and management, Microsoft offers two powerful platforms that have garnered significant attention: Microsoft Fabric Data Analytics and Synapse. Both platforms serve distinct purposes and offer unique features, making it essential for businesses to understand their differences, benefits, and costs. This article delves into the comparison between Microsoft Fabric […]

This post first appeared at https://p3adaptive.com/microsoft-fabric-vs-synapse-a-comprehensive-comparison/. The author is Marketing

Read More

Read More

In the realm of data analytics, Microsoft’s Power BI ecosystem presents a vital choice: Power BI Desktop or Power BI Service. These tools have distinct roles, catering to various data needs. Power BI Desktop, a free Windows application, empowers data professionals to craft comprehensive reports and dashboards, making it an ideal choice for those comfortable […]

This post first appeared at https://p3adaptive.com/what-is-the-difference-between-power-bi-service-and-power-bi-desktop/. The author is Marketing

Read More

Read More

Power BI Desktop

Feb 22, 2024

Are you excited to explore the world of Power BI Desktop and unlock its full potential for data visualization? Whether you’re a business analyst or data scientist considering hiring a Power BI consulting firm or just curious about harnessing the power of data, this guide is your gateway to understanding Power BI Desktop. Let’s kick […]

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

Read More

Read More

The latest Power BI update is here, and it’s all about new enhancements that you’re sure to enjoy. Building on December’s transformative update, we’ve fine-tuned columns, bars, and ribbons, giving you even more control over your visualizations. From border enhancements to IBCS-inspired styles, this release is all about making your reports shine. This post first […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/additional-enhancements-for-columns-bars-and-ribbons/. The author is 

Read More

Read More

We are happy to announce a new Direct Lake semantic model property to control Direct Lake behavior. This post first appeared at https://powerbi.microsoft.com/en-us/blog/leveraging-pure-direct-lake-mode-for-maximum-query-performance/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/leveraging-pure-direct-lake-mode-for-maximum-query-performance/. The author is 

Read More

Read More

We are very excited to announce the adoption of Tabular Model Definition Language (TMDL) as the semantic model file format for the Power BI Project files. This post first appeared at https://powerbi.microsoft.com/en-us/blog/tmdl-in-power-bi-desktop-developer-mode-preview/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/tmdl-in-power-bi-desktop-developer-mode-preview/. The author is 

Read More

Read More

This is it. The way you write DAX changes today with the preview of visual calculations! This post first appeared at https://powerbi.microsoft.com/en-us/blog/visual-calculations-preview/. The author is Read More

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

Read More

Read More

Welcome to the Power BI February 2024 update. We’ve got a lot of great features this month. Here are some key highlights: This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-february-2024-feature-summary/. The author is Read More

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

Read More

Read More

We are excited to announce the general availability (GA) of granular access control for all data connection types, a security feature that enables organizations to have more control over who can bind semantic models to organizational data sources on-prem and in the cloud. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-of-granular-access-control-for-all-data-connection-types/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-of-granular-access-control-for-all-data-connection-types/. The author is 

Read More

Read More

The year 2023 marked a pivotal moment in the data analytics landscape, with Microsoft Fabric Data Analytics emerging as a new player. It aimed to simplify data-related processes and enhance the capabilities of Power BI, a well-established tool in the field. However, professionals sought clarity on how Microsoft Fabric fits into the broader data analytics […]

This post first appeared at https://p3adaptive.com/is-microsoft-fabric-the-same-as-power-bi/. The author is Marketing

Read More

Read More

In the dynamic landscape of data analytics, choosing the right platform for your organization is critical to the success of your data program. Among the myriad options available, Microsoft Fabric Data Analytics and Databricks are two prominent contenders. In this article, we look to uncover the distinctions between them while also delving into their respective […]

This post first appeared at https://p3adaptive.com/microsoft-fabric-vs-databricks-navigating-the-data-analytics-landscape/. The author is Marketing

Read More

Read More

Considering a partnership with a Power BI consulting service? That’s a smart move!  Their team of experts can turn complex data into clear, actionable insights that revolutionize your business strategy. But how much does it cost to avail of this game-changing service?  In this blog post, we aim to shed light on the costs associated […]

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

Read More

Read More

As seasoned experts in the Power BI consulting field, we often come across questions about the future of Power BI. One of the most frequent inquiries is whether Power BI is being discontinued. In this blog post, we’ll address this question and clarify Power BI’s future. Is Power BI Being Discontinued? No, Power BI is […]

This post first appeared at https://p3adaptive.com/unraveling-the-truth-is-power-bi-being-discontinued/. The author is Marketing

Read More

Read More

We are excited to announce the public preview of generating measure descriptions with Fabric Copilot! This post first appeared at https://powerbi.microsoft.com/en-us/blog/generate-measure-descriptions-with-copilot-preview/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/generate-measure-descriptions-with-copilot-preview/. The author is 

Read More

Read More