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

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

Power BI stands out for its seamless integration with Microsoft products, including SharePoint. But how do you connect Power BI to SharePoint? Can you access all the files and extract data from a SharePoint location? As a leading Power BI consulting service, we created this tutorial to help you integrate Power BI with SharePoint. We’ll […]

This post first appeared at https://p3adaptive.com/how-do-i-connect-power-bi-to-a-sharepoint-folder-and-list/. The author is Marketing

Read More

Read More

Consider this—your organization stores valuable data, such as employee information, in a SharePoint list. Now, imagine having the ability to pull this critical data into Power BI, where you can utilize its advanced visualization and analysis capabilities to draw meaningful insights.  At P3 Adaptive, we specialize in Power BI consulting. We have observed how SharePoint […]

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

Read More

Read More

There’s a new M function in Power Query in Power BI that allows you to read the data from a Parquet file: Parquet.Metadata. It’s not documented yet and it’s currently marked as “intended for internal use only” but I’ve been told I can blog about it. Here’s an example of how to use it: let […]

This post first appeared at https://blog.crossjoin.co.uk/2024/02/11/reading-parquet-metadata-in-power-query-in-power-bi/. The author is Chris Webb

Read More

Read More

Microsoft Fabric Data Analytics is now available for users. This platform marks a new dawn in data management, offering an integrated suite of tools designed to simplify and enhance analytics processes. For businesses and individuals alike, understanding how to access and utilize Microsoft Fabric is crucial.  This article delves into its release status, trial features, […]

This post first appeared at https://p3adaptive.com/how-to-get-access-to-microsoft-fabric/. The author is Marketing

Read More

Read More

Microsoft Fabric’s development has been significantly influenced by the concept of Data Mesh, a modern approach to data architecture focused on domain-oriented ownership, data as a product, federated computational governance, and self-serve data platforms.  Microsoft Fabric Data Analytics represents a transformative approach to data analytics, integrating a decentralized Data Mesh architecture to enhance organizational data […]

This post first appeared at https://p3adaptive.com/is-microsoft-fabric-a-data-mesh/. The author is Marketing

Read More

Read More

Microsoft offers a diverse spectrum of certifications, each tailored to different levels of expertise and various professional roles.  Whether it’s the foundational knowledge of Microsoft 365, the intricate workings of Microsoft Fabric Data Analytics, or the advanced capabilities in Azure, these certifications embody a professional’s commitment to staying abreast of technological advancements and their ability […]

This post first appeared at https://p3adaptive.com/are-microsoft-certifications-still-worth-it/. The author is Marketing

Read More

Read More