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
Announcing Power BI app Copilot, now in preview. With app-scoped Copilot, users can search for reports in an app plus ask questions and get connected with answers based on a report in an app. App Copilot is a separate complement to report-scoped Copilot already available on each report viewed in an app. This post first […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-app-copilot-ai-scoped-to-the-curated-content-in-an-app-preview/. The author isWhat’s Changing? Microsoft has announced that Office Online Server (OOS) will be retired effective December 31, 2026. As a result, PBIRS users will no longer be able to host Excel workbooks in PBIRS using OOS after November 2026, in accordance with the PBIRS Support Timelines Policy. Additionally, beginning with the January 2026 PBIRS release, configuration […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/deprecation-announcement-office-online-server-retirement-and-what-it-means-for-power-bi-report-server-users/. The author isThis feature was developed in direct response to feedback from our user community and is designed to provide an efficient tool for managing multiple Power BI add-ins within PowerPoint presentations. Background Power BI Storytelling enables users to embed interactive reports and visuals into PowerPoint, supporting data-driven presentations across organizations. As adoption has grown, many of […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-power-bi-controller-streamlining-storytelling-with-bulk-operations-preview/. The author isIf you’re using Power BI Copilot you may have seen the following warning message: Copilot analyzed only part of the model due to its size, which may affect these results This post first appeared at https://blog.crossjoin.co.uk/2025/10/26/understanding-the-copilot-analyzed-only-part-of-the-model-due-to-its-size-warning-in-power-bi-copilot/. The author is Chris WebbRead More
This post first appeared at https://blog.crossjoin.co.uk/2025/10/26/understanding-the-copilot-analyzed-only-part-of-the-model-due-to-its-size-warning-in-power-bi-copilot/. The author is Chris WebbWe’ve upgraded the Report Copilot experience in Power BI, making it easier than ever to create, edit, and refine beautiful, data-rich reports with the help of AI. With this update, Copilot in Power BI not only helps you create entire report pages in seconds but now also gives you more control, flexibility, and visual intelligence […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-improvements-to-the-report-copilot-in-power-bi/. The author isFollowing on from my blog post a few months ago about cool stuff in the Fabric Toolbox, there is now another really useful solution available there that anyone with Fabric capacities should check out: Fabric Cost Analysis (or FCA). If you have Fabric capacities it’s important to be able to monitor your Azure costs relating […]
This post first appeared at https://blog.crossjoin.co.uk/2025/10/19/monitor-fabric-costs-with-fabric-cost-analysis/?utm_source=rss&utm_medium=rss&utm_campaign=monitor-fabric-costs-with-fabric-cost-analysis. The author is Chris WebbWe are thrilled to announce the release of a new Fabric REST API for configuring connection bindings for semantic models. A connection binding defines what data connection a semantic model will use to connect to an underlying data source. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-a-new-fabric-rest-api-for-connection-binding-of-semantic-models/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-a-new-fabric-rest-api-for-connection-binding-of-semantic-models/. The author isThis month’s update brings exciting opportunities for learning and community engagement, including the upcoming Fabric Data Days and the return of FabCon in Atlanta next spring. Notably, Power BI is making strides in mapping capabilities by transitioning from Bing Maps to Azure Maps, ensuring users have access to the latest features and support. Dive into […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-october-2025-feature-summary/. The author isPBIRS September 2025 Feature Summary This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-september-2025-feature-summary/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-september-2025-feature-summary/. The author isThe new Fabric Graph database is now rolling out now and should be available to everyone within the next few weeks if you can’t see it already. The key to learning a new data-related technology is, I think, to have some sample data that you’re interested in analysing. But if you’re a Power BI person […]
This post first appeared at https://blog.crossjoin.co.uk/2025/10/12/first-look-at-fabric-graph-analysing-power-bi-import-mode-refresh-job-graphs/?utm_source=rss&utm_medium=rss&utm_campaign=first-look-at-fabric-graph-analysing-power-bi-import-mode-refresh-job-graphs. The author is Chris WebbDiscover how Microsoft is transforming data connectivity in Power BI and Microsoft Fabric with a community-driven approach. Learn how you can influence the connector roadmap, submit ideas, vote on priorities, and help shape the future of analytics. This post first appeared at https://powerbi.microsoft.com/en-us/blog/empowering-our-customers-to-shape-the-future-of-data-connectivity-in-power-bi-and-microsoft-fabric/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/empowering-our-customers-to-shape-the-future-of-data-connectivity-in-power-bi-and-microsoft-fabric/. The author isToday, we are excited to introduce new semantic model API enhancements, specifically enabling model authors to update default culture and collation settings for deployed models programmatically. You no longer need to redeploy a semantic model in the Power BI service just to update its default culture, collation, or both. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-semantic-model-apis-to-update-culture-and-collation/. The […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-semantic-model-apis-to-update-culture-and-collation/. The author isUntil now, preparing your data for AI was only possible in Power BI Desktop. That changes today! As of today, we are rolling out the ability for you to prepare your data for AI directly in the Power BI service. This makes it easier to keep your semantic models Copilot-ready without switching tools — and it […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/prep-your-data-for-ai-now-in-the-power-bi-service/. The author isGetting your data job done just got easier with composite semantic models, mixing Direct Lake tables with import tables, now available in public preview. This post first appeared at https://powerbi.microsoft.com/en-us/blog/deep-dive-into-composite-semantic-models-with-direct-lake-and-import-tables/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/deep-dive-into-composite-semantic-models-with-direct-lake-and-import-tables/. The author isThe Metric Sets feature in Power BI will be deprecated, with a phased retirement beginning October 25th, 2025. What’s Changing and When Scorecards and all associated datasets or measures will not be impacted by this change. Recommended alternatives If you have relied on Metric Sets, here are recommended approaches to continue managing and tracking your […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/deprecation-of-metric-sets-in-power-bi/. The author isSince I wrote about the Snowflake query tags generated by Power BI earlier this year, one important piece of functionality has been added: an OperationID that allows you to link a SQL query in Snowflake to events in Workspace Monitoring and the Capacity Metrics app. Let’s see some examples. I created a DirectQuery semantic model […]
This post first appeared at https://blog.crossjoin.co.uk/2025/10/05/snowflake-query-tags-in-power-bi-and-workspace-monitoring/?utm_source=rss&utm_medium=rss&utm_campaign=snowflake-query-tags-in-power-bi-and-workspace-monitoring. The author is Chris WebbIntroducing Trello-Power-BI: Open Source Connector to analyze your Trello boards in Power BI I am excited to share a new open-source project on GitHub: Trello-Power-BI. This post first appeared at https://datachant.com/2025/09/30/analyzing-trello-boards-in-power-bi/. The author is Gil RavivRead More
This post first appeared at https://datachant.com/2025/09/30/analyzing-trello-boards-in-power-bi/. The author is Gil RavivFollowing on from my post two weeks ago about how to get the details of Power BI operations seen in the Capacity Metrics App using the OperationId column on the Timepoint Detail page, I thought it was important to point out that you can do the same thing with TSQL queries against a Fabric Warehouse/SQL […]
This post first appeared at https://blog.crossjoin.co.uk/2025/09/28/linking-fabric-warehouse-sql-queries-and-spark-jobs-to-the-capacity-metrics-app/?utm_source=rss&utm_medium=rss&utm_campaign=linking-fabric-warehouse-sql-queries-and-spark-jobs-to-the-capacity-metrics-app. The author is Chris WebbTMDL view is now generally available in Power BI Desktop! This post first appeared at https://powerbi.microsoft.com/en-us/blog/tmdl-view-generally-available/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/tmdl-view-generally-available/. The author isPower BI in Teams – Content Shared in Teams Chats Now Opens a Dedicated Separate Window Within Teams This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-in-teams-content-shared-in-teams-chats-now-opens-a-dedicated-separate-window-within-teams/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-in-teams-content-shared-in-teams-chats-now-opens-a-dedicated-separate-window-within-teams/. The author is