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

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

The more you monitor something the more likely it is that you’ll see something strange you can’t explain. This is true of several customers I’ve spoken to recently who saw DAX queries run in the middle of the night by people who were definitely not online at the time and who were worried about the […]

This post first appeared at https://blog.crossjoin.co.uk/2024/02/18/query-caching-in-power-bi-premium/. The author is Chris Webb

Read More

Read More

As part of our continued tooling improvements, we have enhanced the experience for creating Direct Lake semantic models in Microsoft Fabric. This applies to semantic models created by clicking the New semantic model button from the Lakehouse. This post first appeared at https://powerbi.microsoft.com/en-us/blog/improvements-for-creating-new-direct-lake-semantic-models/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/improvements-for-creating-new-direct-lake-semantic-models/. The author is 

Read More

Read More

Picture yourself navigating through a maze of data, with each turn presenting a new array of numbers and charts. In this scenario, Microsoft Power BI is your reliable flashlight, casting light on the essential details and patterns within this data labyrinth.  Conversely, Microsoft Fabric data analytics is your intuitive GPS. It not only guides you […]

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

Read More

Read More

The comparison between Microsoft Fabric and Power BI has become a central topic for many professionals in the field of data analytics and data science. Each platform plays a crucial role in shaping business intelligence strategies. While they are often considered alternatives, especially with recent administrative naming changes, they serve different purposes.  From data movement […]

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

Read More

Read More