The (Almost) Definitive Guide to Query Folding - It's Not About The Cell
There’s only one rule. Don’t break the fold! Before we start enforcing all these rules, we should start with something like a solid foundation of what does and doesn’t fold in Power Query and their SQL equivalents. Now, if you found this page and we’re like “what in the world is query folding?” read this […]
Learn Power BI for FREE with an M365 Developer License
Are you interested in learning Power BI, but want to do it outside of your corporate environment? We’ve got great news for you! You can sign-up for the Microsoft 365 Developer Program entirel…
Make Your Goals a Reality with OKRs and New Capabilities from Microsoft Viva Goals
As we enter a new year, more gyms are packed, more books are read, but within the first month, about a third of individuals will see a dissolution of their goals. Setting goals and sticking to them isn’t just a challenge for personal pursuits—it holds true for your professional life too. Organiza...
Build beautiful, usable products faster. Material Design is an adaptable system—backed by open-source code—that helps teams build high quality digital experiences.
Get up to speed with PowerShell Hashtable: a powerful data structure for storing key-value pairs. Learn the basics and gain insights into advanced features.
Business Intelligence Job Profiles – How to Play to Your Strengths, Find Your Niche, and Build Your Career - Olivier Travers
My post on which languages to learn as a Power BI developer resonated with many people so I thought I'd take a step back and write about how to navigate the various facets of the business intelligence job market. Where language selection is effectively a tactical tool choice, in this entry we'll focus on the
(Livestream Replay) No More Data Quality Surprises! - with Dave Ruijter — Havens Consulting
ABSTRACT 📄 Do you know your data? Do you have confidence in the data of your Power BI solutions, no matter what? And do you already actively monitor for deviations from those expectations? Being in control of your data (quality) is essential for any solution, and it can be quite difficult to achie
This article describes different techniques to debug a DAX measure that returns an incorrect result, with and without external tools. Finding errors in DAX
Aggregation Options in Power BI and SQL Server Analysis Services - Olivier Travers
Pre-computing aggregates from granular data to improve live performance for end users by using computing resources at scheduled times is a well-established software pattern. In this entry we'll look at how to set up aggregations across Microsoft business intelligence products. This functionality breaks the pattern of how most features have flown through the genealogy of
Unpivot a matrix with multiple fields on columns in Power Query
I had to do this for a client the other day, and I realized I hadn’t blogged about it. Let’s say you need to include data in a Power BI model, but the only source of the data is a matri…
Announcing My workspace governance improvement (Public Preview)
Announcing Public Preview of new My workspace governance features that address some of the pain points of governing My workspaces for Power BI Service Admins
Announcing Connected Excel Tables from Power BI (Public Preview)
This feature allows users to export an Excel table from a Power BI report and keep that table connected to Power BI by refreshing it in the Excel grid.
Master DP-500 Skills with "Mastering DP-500 Azure Enterprise Data Analyst" on-demand course! - Data Mozart
It's LIVE! Are you dreaming of advancing your career by getting the most in-demand certificate? This course walks you through each and every topic necessary to master the skills required for the DP-500 exam (Azure Enterprise Data Analyst)