Tag
10 posts
January 2, 2026
Mike and Tommy revisit Dataflows Gen 2 after giving it a hard time for months — and the verdict? It's actually good now. New parallelization, modern query evaluation, and smarter pricing make it a real option again. Plus, the PBIR format admin setting and creative image visual tricks.
July 21, 2025
Alex Powers joins the Explicit Measures podcast to deep dive into optimizing Power Query for maximum performance, covering dataflows Gen 1 vs Gen 2, query folding, staging patterns, and the evolving role of Power Query in Microsoft Fabric.
August 31, 2016
Create a custom dynamic date table in Power BI Query Editor using M language. Build week-based selectors that automatically update when refreshed.
August 10, 2016
Learn how to load multiple Excel files from a folder into Power BI using a custom function. Combine workbooks with multiple sheets into a single query.
August 4, 2016
Learn how to create a variable query in Power BI to manage file locations. When you move files, update one query instead of changing every source path.
June 16, 2016
Learn how to automatically load only the most recent file from a folder in Power BI. Perfect for automated reports that receive daily data files.
May 19, 2016
Learn how to copy and paste queries to and from the Query Editor using the Advanced Editor. Master the M language to share and model your Power BI data.
April 20, 2016
Learn how to pull data directly from Wikipedia into Power BI and create a beautiful filled map showing US population growth by state.
April 11, 2016
Learn how to troubleshoot and fix broken file connections in Power BI Desktop when your data source has moved or can't be found.
April 7, 2016
Learn how to load multiple files from a folder into Power BI Desktop using the powerful automated data loading feature that will change how you work with data.