Select Page
In The Trenches

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

Paul Hansen is an experienced Analytics Engineer and Senior BI Developer, skilled in data architecture, ETL processes, and data visualization. He has a strong background in SQL, Python, and cloud platforms like AWS and Azure. Paul has led teams to create integrated data solutions, leveraging tools such as dbt, SSIS, and Power BI. His recent roles have ranged from Senior BI Developer to BI Team Lead, demonstrating his ability to manage complex projects and deliver insightful business intelligence solutions. Paul values a collaborative work environment that fosters innovation and professional growth.

Please access his resume here:
Paul Hansen – Business Intelligence Professional 2023
LinkedIn Profile: https://www.linkedin.com/in/paulhansenza/

Contact Me

Business Intelligence and Analytics Blog

This month, we’re excited to share a major milestone for Power BI modelling tools – Power BI Desktop is now compatible with any semantic model in Fabric. With this update, you’re no longer required to rely on external tools to edit a semantic model running in Fabric. At the same time, it enhances interoperability between […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/open-and-edit-any-semantic-model-with-power-bi-tools/. The author is 

Read More

Read More

This month’s update highlights several exciting preview features and an important action-required item for Power BI users. In preview, you’ll find updates to visual calculations, enhancements to numeric range and field parameters, both designed to offer greater flexibility and analytical power within your reports. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-june-2025-feature-summary/. The author is Read More

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

Read More

Read More

What’s new in SSAS 2025 This post first appeared at https://powerbi.microsoft.com/en-us/blog/whats-new-in-sql-server-2025-analysis-services/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/whats-new-in-sql-server-2025-analysis-services/. The author is 

Read More

Read More

This week, we’re excited to announce the availability of two new Copilot experiences in Power BI. First, the Chat with your Data experience, which we announced two weeks ago at Build is fully rolled out. Additionally, Copilot is now supported in securely embedded Power BI reports for portals and websites, enabling users to engage with […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/now-available-two-new-copilot-experiences/. The author is 

Read More

Read More

Without a doubt the most important new feature in Power BI Copilot is AI Instructions: it opens up an immense number of possibilities but it also starts off as a blank slate, which raises the question of what you should do with this feature as much as how you should do it. The official documentation […]

This post first appeared at https://blog.crossjoin.co.uk/2025/06/08/requiring-selections-on-the-date-dimension-in-power-bi-copilot-ai-instructions/?utm_source=rss&utm_medium=rss&utm_campaign=requiring-selections-on-the-date-dimension-in-power-bi-copilot-ai-instructions. The author is Chris Webb

Read More

Read More

Starting on June 11, the new PL-300 livestream series takes away the jargon and gives you real, digestible Power BI content in a live format (with actual experts you can talk to). Learning Power BI is like giving your career night vision goggles. Suddenly, patterns appear. Decisions make more sense. And you become the go-to person for insight, […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/your-road-to-power-bi-certification-starts-here/. The author is 

Read More

Read More

By the time you read this it’s likely the new, standalone Power BI “Chat with your data” experience will be available in your tenant. I just enabled it in the tenant the Fabric CAT team uses for testing purposes, located in the West Europe region, after the option to do so appeared yesterday. If you’re […]

This post first appeared at https://blog.crossjoin.co.uk/2025/06/01/finding-reports-and-semantic-models-easily-with-power-bi-copilot-search/?utm_source=rss&utm_medium=rss&utm_campaign=finding-reports-and-semantic-models-easily-with-power-bi-copilot-search. The author is Chris Webb

Read More

Read More

Power BI Report Server May 2025 Feature Summary This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-may-2025-feature-summary/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-may-2025-feature-summary/. The author is 

Read More

Read More

As a Power Query fan I’m naturally interested in Copilot in Dataflows Gen2. But since Power Query is already very easy to use and since I’m pretty experienced at using it, can Copilot really do anything to help me be more productive? Well one thing I need to do a lot for blog posts, demos […]

This post first appeared at https://blog.crossjoin.co.uk/2025/05/25/generating-sample-data-with-copilot-in-fabric-dataflows-gen2/?utm_source=rss&utm_medium=rss&utm_campaign=generating-sample-data-with-copilot-in-fabric-dataflows-gen2. The author is Chris Webb

Read More

Read More

The May 2025 Power BI update introduces a range of exciting advancements to Power BI, including a standalone Copilot feature allowing users to “Ask Anything!” in preview, enhanced language understanding for data-related questions, and an important announcement regarding the deprecation of the 32-bit Power BI Desktop build. Packed with valuable updates and insights, this month’s […]

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

Read More

Read More

We’re excited to announce the public preview of a new chat with your data experience in Power BI. This new standalone, full-screen Copilot experience, easily accessible from the left navigation of Fabric, can help you find and ask questions about any data you have access to. This post first appeared at https://powerbi.microsoft.com/en-us/blog/the-next-era-of-copilot-in-power-bi-chat-with-your-data/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/the-next-era-of-copilot-in-power-bi-chat-with-your-data/. The author is 

Read More

Read More

We are thrilled to announce that Power BI report buttons can now run Fabric User data functions for custom, automated action, including data write-back. This marks a major evolution in Power BI reports to support all kinds of translytical task flows, such as updating records, dynamic notifications, adding annotations, or even creating powerful workflows that […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-translytical-task-flows-preview/. The author is 

Read More

Read More

If you have a Power BI report with a matrix visual on it it’s quite likely that you’ll want all the levels in the matrix to be fully expanded by default. But did you know that the way you expand all the levels could have performance implications, especially if you’re using DirectQuery mode? Here’s an […]

This post first appeared at https://blog.crossjoin.co.uk/2025/05/18/performance-implications-of-different-ways-of-fully-expanding-a-power-bi-matrix-visual/?utm_source=rss&utm_medium=rss&utm_campaign=performance-implications-of-different-ways-of-fully-expanding-a-power-bi-matrix-visual. The author is Chris Webb

Read More

Read More

If you’ve worked with calculation groups, you know how powerful they are for simplifying measure logic and enhancing report functionality. It doesn’t stop there though; selection expressions offer even more fine-tuned control. This post first appeared at https://powerbi.microsoft.com/en-us/blog/deep-dive-into-selection-expressions-for-calculation-groups/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/deep-dive-into-selection-expressions-for-calculation-groups/. The author is 

Read More

Read More

Over the last few years one topic I have blogged about several times is how to link the detailed data about DAX query execution that can be found in Log Analytics – and now Workspace Monitoring – to the visual in a Power BI report that generated those DAX queries, something that is extremely useful […]

This post first appeared at https://blog.crossjoin.co.uk/2025/05/11/finding-events-linked-to-a-specific-power-bi-visual-in-fabric-workspace-monitoring/?utm_source=rss&utm_medium=rss&utm_campaign=finding-events-linked-to-a-specific-power-bi-visual-in-fabric-workspace-monitoring. The author is Chris Webb

Read More

Read More

Level: Beginners Original: Feb 2016 It has been many years since Matt wrote his first take on Calculated Columns vs Measures, back in 2014 when he wrote the blog post 5 common mistakes of self taught DAX students at PowerPivotPro.com.  Since then Matt expanded his ideas with the original release […]Read More » This post […]

This post first appeared at https://exceleratorbi.com.au/calculated-columns-vs-measures-dax-2/. The author is Jason Cockington

Read More

Read More

This update comes with a marked improvement when generating DAX queries and conversationally editing them. This includes overall correctness of the DAX queries and Copilot shows a deeper understanding of how to utilize DAX. This post first appeared at https://powerbi.microsoft.com/en-us/blog/fabric-copilot-to-help-write-dax-queries-improvements/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/fabric-copilot-to-help-write-dax-queries-improvements/. The author is 

Read More

Read More

The unification of Power BI datamarts with Fabric data warehouses offers a significant evolution in Microsoft’s analytics capabilities. By addressing user feedback and enhancing features such as scalability, security, and AI integration, Fabric data warehouses offer a robust solution for modern data needs. We encourage users to migrate their existing datamarts to Fabric data warehouses […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/unify-datamart-with-fabric-data-warehouse/. The author is 

Read More

Read More

In the rapidly evolving ‌landscape of data ‌warehousing, organizations are ​constantly seeking platforms that not ‍only⁣ store vast amounts⁢ of details but also enable swift, insightful analysis. ‍Two heavyweights ‍frequently enough ​emerge in these conversations: Snowflake Data Warehouse and Microsoft SQL Server. While both have ​established their reputations, ​the nuances ‍and innovations embedded in ⁤Snowflake’s […]

Read More

AI is meant to help us automate boring tasks, and what could be more boring than creating documentation for your Power BI semantic models? It’s such a tedious task that most people don’t bother; there’s also an ecosystem of third party tools that do this job for you, and you can also build your own […]

This post first appeared at https://blog.crossjoin.co.uk/2025/05/04/documenting-power-bi-semantic-models-with-fabric-data-agents/?utm_source=rss&utm_medium=rss&utm_campaign=documenting-power-bi-semantic-models-with-fabric-data-agents. The author is Chris Webb

Read More

Read More