The blog
Notes on Power BI, Fabric and AI.
Guides, case studies and how-tos, going back to the early days of Power Pivot.
All posts
Newest first. Just scroll.
AI Data Management
Power Query (M)agic Part 2: Organizing Your Queries
Learn how to use Power Query like a pro and organize your queries by using this very simple technique. Take your queries and organize them in folders.
Read the article
Power BI
Why Excel’s Power Query Refresh Speeds Suck
Ever noticed that Power Query refresh is slower in Excel than Power BI? Ken Puls, PQ Expert, explains the problem and what you can do to fix it!
Read the article
Power BI
My Top 5 Power BI Visual Design Practices: Transforming Good to GREAT
I’d like to drop some reporting knowledge. I’m going to share some of my best practices for Power BI Reporting I’ve developed over the years
Read the article
Data Strategy
M/Power Query “Sets Up” DAX, so Learn DAX (and Modeling) First
You should advance to Intermediate in DAX before advancing to Intermediate in Power Query / M, and then to Mastery of DAX before Mastery of M.
Read the article
Power BI
Ten Ways to Deliver Business Impact with Power BI
A simple description about ten things Power BI and data can do for you, along with bonus honorable mentions as well.
Read the article
Power BI
Import all CSV files from a folder with their filenames in Power BI
A description on how to import CSV files into Power BI with their filenames.
Read the article
Power BI
Power Query as a File Audit Tool
Today I am sharing how I use Power Query as a file audit tool to support a regular task I complete every week. The objective of this post is to create broader awareness of how great Power Query is to solve different types of problems, and to possibly get you thinking about other problems you have that could be solved with this tool.
Read the article
Power BI
Data Modeling for Power Pivot and Power BI
An article on Data Modeling for Power Pivot and Power BI as well as a brief explanation about what we do written by the experts at P3 Adaptive .
Read the article
Power BI
Giving Back: “Steal” this Reference Card!
A long time coming… The Finalized 8-Page “Reference Card V2” – Download it for Free Below Yes, this took me forever. I first posted about it more than
Read the article
Power BI
Share and Refresh Power Query & PBI Get Data with Local Links
The concept of parameter tables in Power Query will be familiar to some and new to others. A parameter table is a way that you can “pass” values to Power Query (and also Power Pivot) and these values can then be used in your queries and/or the data model.
Read the article
Power BI
Consolidated Worksheets with Power Query
The more I use Power Query, the more I want to use Power Query – and of course the more I learn.
Read the article
Power BI
DAX – The Diabolical Genius of “SWITCH TRUE”
SWITCH() is still testing for equivalence! By providing the first argument as TRUE(), now each subsequent “test” will check for TRUE().
Read the article