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
Welcome to November and a new version of the on-premises data gateway! We are excited to announce a new feature for allowlisting which tenants can register an on-premises data gateway on a machine. Read the post to find out more. This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-november-2023-release/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-november-2023-release/. The author isRecently I was involved in an interesting discussion on Twitter X about how partitioning a table in a Power BI dataset semantic model can affect compression and therefore its size and query performance. You can read the thread here. It got me thinking: is there a way to get more detail on how well compression, […]
This post first appeared at https://blog.crossjoin.co.uk/2023/11/05/exploring-power-bi-run-length-encoding-with-dmvs/. The author is Chris WebbIf you’re a fan of using Log Analytics for monitoring Power BI activity, then you may have noticed there’s some new data in the ApplicationContext column of the PowerBIDatasetsWorkspace table. Up until recently the ApplicationContext column only contained IDs that identify the report and the visual that generated a DAX query (something I blogged about […]
This post first appeared at https://blog.crossjoin.co.uk/2023/10/29/new-hostproperties-data-in-the-applicationcontext-column-in-power-bi-log-analytics/. The author is Chris WebbThe “GetCapacityTenantSettingOverrides” API is a response to the concerns raised by tenant administrators. It offers transparency and insight that administrators need to govern Fabric. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-a-new-admin-api-to-get-insights-into-tenant-setting-overrides-at-capacity-level/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-a-new-admin-api-to-get-insights-into-tenant-setting-overrides-at-capacity-level/. The author isBack in 2021 I wrote a post showing how you can link a DAX query generated by a Power BI report in Log Analytics to a visual in a Power BI report. In that post I showed how you can get the unique IDs for each visual in a report using Performance Analyzer, an approach […]
This post first appeared at https://blog.crossjoin.co.uk/2023/10/22/getting-report-visual-ids-with-power-bi-desktop-developer-mode/. The author is Chris WebbWelcome to October! We have a few new announcements this month, so be sure to read until the end! We are especially excited to announce a new PowerShell cmdlet for adding a gateway to an existing cluster. This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-october-2024-release/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-october-2024-release/. The author isWelcome to October! We have a few new announcements this month, so be sure to read until the end! We are especially excited to announce a new PowerShell cmdlet for adding a gateway to an existing cluster. This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-october-2023-release/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-october-2023-release/. The author isYou asked, we deliver! The option to create a customized pipeline of 2-10 stages is now available. Check it out! This post first appeared at https://powerbi.microsoft.com/en-us/blog/deployment-pipelines-a-customized-pipeline-is-finally-here/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/deployment-pipelines-a-customized-pipeline-is-finally-here/. The author isThe foundation of centralized connection management is granular access control. Power BI always enforces granular access control for shareable cloud connections (SCCs). For all other data connection types, it can be enabled at the tenant, workspace, and dataset level. This post first appeared at https://powerbi.microsoft.com/en-us/blog/enabling-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/enabling-granular-access-control-for-all-data-connection-types/. The author isThe model view now has even more to offer! We are excited to share the public preview of the Model explorer in the model view of Power BI Desktop. This post first appeared at https://powerbi.microsoft.com/en-us/blog/deep-dive-into-the-model-explorer-with-calculation-group-authoring-and-creating-relationships-in-the-properties-pane/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/deep-dive-into-the-model-explorer-with-calculation-group-authoring-and-creating-relationships-in-the-properties-pane/. The author isPower BI is a powerful tool for businesses. However, for business decision-makers, Power BI consulting is only as valuable as the knowledge of those wielding it. That’s where Power BI consultants come in. Let’s dive in. What Is Power BI? Microsoft Power BI is a data visualization software. It is renowned for its top-tier capabilities, […]
This post first appeared at https://p3adaptive.com/2023/10/what-does-a-power-bi-consultant-do/. The author is Rob CollieIn the Power BI/Fabric community everyone is excited about the recent release of Semantic Link: the ability to analyse Power BI data easily using Python in Fabric notebooks. Sandeep Pawar has an excellent blog post here explaining what this is and why it’s so cool. Meanwhile in the Excel community, everyone is excited about the […]
This post first appeared at https://blog.crossjoin.co.uk/2023/10/15/analyse-power-bi-data-in-excel-with-python/. The author is Chris WebbWelcome to the October 2023 update. We’ve got a lot of great features this month including OneDrive and SharePoint integration, updates to On-object Interaction, and deduplication rules for composite models. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-october-2023-feature-summary/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-october-2023-feature-summary/. The author isWe have some very exciting news to share with you today! We are thrilled to announce that we have just launched the public preview of Direct Lake mode for Power BI datasets in Fabric! Fabric is taking a bold bet on open data formats in OneLake. This post first appeared at https://powerbi.microsoft.com/en-us/blog/troubleshooting-automatic-aggregations-to-optimize-directquery-performance/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/troubleshooting-automatic-aggregations-to-optimize-directquery-performance/. The author isIf you’ve heard about the new Direct Lake mode for Power BI datasets in Fabric you’ll know that it gives you the query performance of Import mode (well, almost) without the need to actually import any data. Direct Lake datasets can be refreshed though – in fact, they refresh automatically by default – and if […]
This post first appeared at https://blog.crossjoin.co.uk/2023/10/08/what-does-it-mean-to-refresh-a-direct-lake-power-bi-dataset-in-fabric/. The author is Chris WebbExclusive opportunity for Women interested in Power BI, led by female trainers in select countries. Register for a free, hands-on workshop where you will learn how to build a Dashboard in a Day! Learn more here – https://aka.ms/DIAD4Women This post first appeared at https://powerbi.microsoft.com/en-us/blog/exclusive-dashboard-in-a-day-for-women-led-by-women/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/exclusive-dashboard-in-a-day-for-women-led-by-women/. The author isPower BI OneDrive and SharePoint integration enabling by default roll out has started This post first appeared at https://powerbi.microsoft.com/en-us/blog/24762/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/24762/. The author isThis week, one of my colleagues at Microsoft, Nat Van Gulck, showed me a cool new open-source tool he’s been working on to make VisOps for Power BI much easier: PBI Inspector. What is VisOps? I’ll admit I didn’t really know either, so being lazy I asked Nat to write a few paragraphs describing the […]
This post first appeared at https://blog.crossjoin.co.uk/2023/10/01/visops-for-power-bi-with-pbi-inspector/. The author is Chris WebbEnhance viewing capabilities for Power BI Report Server in the September 2023 release. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-september-2023-feature-summary/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-september-2023-feature-summary/. The author isWe have released today a new version of the Template Apps Exploration Tool app on AppSource. The new app is now labeled as Power BI Apps on AppSource – Exploration Tool. This is the only Power BI app that analyzes all the Power BI apps on AppSource. You can install the app here. This post […]
This post first appeared at https://datachant.com/2023/09/26/power-bi-apps-on-appsource-exploration-tool/. The author is Maya Raviv