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

Connect to100+ data sources and create paginated reports. This post first appeared at https://powerbi.microsoft.com/en-us/blog/get-data-with-power-query-available-in-power-bi-report-builder-preview/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/get-data-with-power-query-available-in-power-bi-report-builder-preview/. The author is 

Read More

Read More

We are excited to announce that Mirroring, previously announced at Ignite in November 2023, is now available to customers in Public Preview. You can now seamlessly bring your databases into OneLake in Microsoft Fabric, enabling seamless zero-ETL, near real-time insights on your data – and unlocking warehousing, BI, AI, and more.  This post first appeared […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-public-preview-of-database-mirroring-in-microsoft-fabric/. The author is 

Read More

Read More

Power BI March 2024 Feature Summary This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-march-2024-feature-summary/. The author is Read More

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

Read More

Read More

I recently took part in a webinar with Denny Lee, Liping Huang and Marius Panga from Databricks on the subject of best practices for using Power BI on Databricks. You can view the recording on LinkedIn here: https://www.linkedin.com/video/live/urn:li:ugcPost:7174102151407779841 This post first appeared at https://blog.crossjoin.co.uk/2024/03/24/best-practices-for-power-bi-on-databricks-webinar/. The author is Chris WebbRead More

This post first appeared at https://blog.crossjoin.co.uk/2024/03/24/best-practices-for-power-bi-on-databricks-webinar/. The author is Chris Webb

Read More

Read More

As Power BI continues to dominate the data analytics and visualization space, the demand for skilled Power BI professionals is on the rise. Individuals and organizations alike are seeking effective ways to harness the capabilities of Power BI to transform raw data into insightful, actionable information by hiring Power BI Developers and/or Power BI consulting […]

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

Read More

Read More

In data analytics, Power BI has emerged as a pivotal tool for professionals aiming to leverage data visualization and analysis to drive decision-making processes. With the increasing demand for skilled data analysts in the business world, obtaining a Power BI certification has become a sought-after achievement for many. This certification, especially the Microsoft Power BI […]

This post first appeared at https://p3adaptive.com/is-it-hard-to-get-a-power-bi-certification/. The author is Marketing

Read More

Read More

With the advent of new and increasingly sophisticated analytics tools like Power BI within the Microsoft ecosystem, mastering these platforms has become indispensable for professionals spanning a myriad of industries. Power BI emerges as a formidable tool in the realm of data visualization, enabling users to not only see but also interact with data in […]

This post first appeared at https://p3adaptive.com/power-bi-certification-a-comprehensive-guide/. The author is Marketing

Read More

Read More

Welcome to the March 2024 release of the on-premises data gateway! Read more to learn about our support for service principals. This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-march-2024-release/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-march-2024-release/. The author is 

Read More

Read More

This month, we are excited to announce some new and exciting updates to Copilot; This post first appeared at https://powerbi.microsoft.com/en-us/blog/copilot-updates-march-2024/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/copilot-updates-march-2024/. The author is 

Read More

Read More

There’s a lot of excitement about Copilot in Power BI and in Fabric as a whole. The number one question I’m asked about Copilot by customers is “How much does it cost?” and indeed there have been two posts on the Fabric blog here and here attempting to answer this question. The point I want […]

This post first appeared at https://blog.crossjoin.co.uk/2024/03/17/how-much-does-copilot-cost-in-microsoft-fabric/. The author is Chris Webb

Read More

Read More

In today’s fast-paced digital world, information is power, especially when it comes to mastering the intricacies of software development and deployment. One key player in this arena is Microsoft, with its comprehensive approach to documentation, notably through platforms like Microsoft Fabric Data Analytics. But before diving into the specifics of Microsoft’s offerings, let’s explore the […]

This post first appeared at https://p3adaptive.com/does-microsoft-have-a-documentation-tool/. The author is Marketing

Read More

Read More

In today’s fast-paced business world, understanding data is crucial for making informed decisions. This is where Microsoft’s Power BI comes into play, offering a powerful platform that simplifies complex data into understandable insights. As Power BI becomes more popular across various industries, many newcomers are left wondering: Is Power BI easy for beginners to learn? […]

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

Read More

Read More

In the dynamic world of business intelligence, Microsoft’s Power BI stands out for its ability to turn complex data into comprehensive insights. As it becomes increasingly integral to data-driven strategies, many are evaluating the feasibility of learning Power BI and the advantages of Power BI Consulting for organizational analytics. Is Power BI Easy to Learn? […]

This post first appeared at https://p3adaptive.com/is-power-bi-easy-or-hard-to-learn/. The author is Marketing

Read More

Read More

With the exciting release of Microsoft Fabric and the Fabric capacity SKUs last year, we are consolidating purchase options and retiring the Power BI Premium per capacity SKU after January 1, 2025. This post first appeared at https://powerbi.microsoft.com/en-us/blog/important-update-coming-to-power-bi-premium-licensing/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/important-update-coming-to-power-bi-premium-licensing/. The author is 

Read More

Read More

Last week I again had the pleasure of being invited by Rob Collie to be on his podcast Raw Data by P3 Adaptive.  For those that are not familiar with my story, I identified Rob as a leader in the Power Pivot/Power BI space very early on (back in the […]Read More » This post […]

This post first appeared at https://exceleratorbi.com.au/my-latest-podcast-with-rob-collie-from-p3-adaptive/. The author is Matt Allington

Read More

Read More

In today’s digital era, where data is king, Microsoft Fabric Data Analytics stands out as a groundbreaking solution for organizations keen on leveraging their data to its fullest potential. Launched amid much anticipation, Microsoft Fabric has quickly become a cornerstone for data-driven strategies, thanks to its comprehensive suite of analytics tools. Designed to integrate seamlessly […]

This post first appeared at https://p3adaptive.com/when-should-i-choose-microsoft-fabric/. The author is Marketing

Read More

Read More

In today’s data-driven world, the ability to analyze and visualize data has become a crucial skill across many industries. Power BI, Microsoft’s interactive data visualization tool, is at the forefront of this revolution, enabling users to make informed decisions by transforming raw data into compelling insights. The question on many aspiring data professionals’ minds is: […]

This post first appeared at https://p3adaptive.com/can-i-learn-power-bi-by-myself/. The author is Marketing

Read More

Read More

Changing Power BI add-in as snapshot made easy and with more options. You can now change your live data to an image, that only people who can see the report will be able to see. This post first appeared at https://powerbi.microsoft.com/en-us/blog/improved-image-mode-in-power-bi-add-in-for-powerpoint/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/improved-image-mode-in-power-bi-add-in-for-powerpoint/. The author is 

Read More

Read More

Many Power BI connectors for relational databases, such as the SQL Server connector, have an advanced option to control whether relationship columns are returned or not. By default this option is on. Returning these relationship columns adds a small overhead to the time taken to open a connection to a data source and so, for […]

This post first appeared at https://blog.crossjoin.co.uk/2024/03/10/overhead-of-getting-relationship-columns-in-power-bi-directquery-mode/. The author is Chris Webb

Read More

Read More

We are excited to announce the February release of the on-premises data gateway! This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-february-2024-release/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-february-2024-release/. The author is 

Read More

Read More