PowerBI.tips

Posts – Page 6

Page 6 of 25

Looking at the Warehouse Roadmap – Ep. 454

Aug 29, 2025

Looking at the Warehouse Roadmap – Ep. 454

Mike and Tommy walk through the Fabric Data Warehouse roadmap—what's coming, what's already shipped, and where warehouse fits in the broader Fabric story. Plus, materialized lake views and notebook UDF integration.

Creature Comforts of Data Warehouse – Ep. 453

Aug 27, 2025

Creature Comforts of Data Warehouse – Ep. 453

Mike and Tommy discuss the latest Fabric Data Warehouse improvements—migration assistant, SQL endpoint refresh upgrades, snapshots, and the 'creature comforts' that make warehouse feel more like home for SQL professionals.

Calculation Groups in Practice – Ep. 452

Aug 22, 2025

Calculation Groups in Practice – Ep. 452

Mike and Tommy explore calculation groups in practice—one of DAX's most powerful features for reducing measure proliferation and creating dynamic calculation patterns. They reference SQLBI's deep dives and Bernat's practical blog posts.

Lets Talk SQL and New Features: The Future? – Ep. 451

Aug 20, 2025

Lets Talk SQL and New Features: The Future? – Ep. 451

Mike and Tommy discuss the evolving role of SQL in Fabric—what's new and coming soon in the SQL analytics endpoint, connecting Fabric SQL to Desktop, and whether SQL is gaining or losing ground in the modern data stack.

The End of the Line for Datamarts – Ep. 450

Aug 15, 2025

The End of the Line for Datamarts – Ep. 450

Mike and Tommy discuss the end of Power BI Datamarts—Microsoft's plan to unify datamarts with Fabric Data Warehouse. They cover what this means for current datamart users, the migration path, and whether datamarts ever found their audience.

Translytical Is So Much More – Ep. 447

Aug 6, 2025

Translytical Is So Much More – Ep. 447

Mike and Tommy unpack translytical task flows in Power BI—a feature that goes far beyond the Gartner buzzword. Plus news on OneLake as a source for COPY INTO and a new Fabric Notebooks competition.

AI Is Now Ready – SQLBI – Ep. 446

Aug 1, 2025

AI Is Now Ready – SQLBI – Ep. 446

Mike and Tommy discuss SQLBI's bold claim that AI in Power BI is ready to pay attention to—driven by MCP servers that let AI agents query and control Power BI. Plus the Fabric July 2025 feature summary.

Evolution of an Analyst – Ep. 445

Jul 30, 2025

Evolution of an Analyst – Ep. 445

Mike and Tommy celebrate Power BI's 10th anniversary by reflecting on the evolution of the data analyst role. Plus: the default semantic model is finally being sunset, and Fabric data agents get multi-agent orchestration.

Optimal Power BI Architecture in Fabric – Ep. 444

Jul 25, 2025

Optimal Power BI Architecture in Fabric – Ep. 444

Mike and Tommy tackle a mailbag question about the optimal Power BI architecture in the Fabric era versus the pre-Fabric world of dataflows and shared datasets. They explore how the lakehouse, notebooks, and AI agents are reshaping what 'better' really means for data teams.

Future-Proofing Excel – Ep. 443

Jul 23, 2025

Future-Proofing Excel – Ep. 443

Mike and Tommy answer a mailbag question about building Excel dashboards with future migration in mind. They break down practical steps for making the leap from Excel to Power BI easier — starting with Power Query, tables, and pivot charts.

Data Science with Ginger Grant

Jul 21, 2025

Data Science with Ginger Grant

Tommy and Mike discuss the state of Data Science as it relates to Fabric. Learn from MVPs where you should invest your time with Fabric and Data Science.

DevOps with Matthias Thierbach

Jul 21, 2025

DevOps with Matthias Thierbach

The explicit measures podcast unpacks what DevOps means. It's not software, it's a way of thinking. Matthias is the creator of the beloved TMDL format.

What's up with DAX? – Ep. 442

Jul 18, 2025

What's up with DAX? – Ep. 442

Mike and Tommy refocus on DAX after weeks of Fabric talk. They cover the Power BI July 2025 feature summary, discuss what companies are actually doing about Fabric adoption, and dive deep into the current state and future of DAX.

What is Your Numeracy? – Ep. 441

Jul 16, 2025

What is Your Numeracy? – Ep. 441

Mike and Tommy explore the concept of numeracy — how well does your team actually understand analytics? They discuss skills matrices for Fabric adoption and whether we can (and should) test for data literacy on our teams.

Fabric June 2025 Feature Draft – Ep. 439

Jul 9, 2025

Fabric June 2025 Feature Draft – Ep. 439

Mike and Tommy break down the Fabric June 2025 update with a rapid-fire draft of the features they’re most excited about. They also cover Copilot inline code completion in Fabric notebooks, shortcut transformations from files to Delta tables, and new data agent data-source instructions.

Who Owns the Connection? Managing Access and Chaos in Fabric Pipelines – Ep. 438

Jul 4, 2025

Who Owns the Connection? Managing Access and Chaos in Fabric Pipelines – Ep. 438

Mike and Tommy dig into a very real Fabric pain point: connections that get created by one developer and become invisible or unusable for everyone else. They share practical governance patterns—especially security-group driven ownership—and what Microsoft could improve to reduce friction and ‘paper cuts’ in team-based pipelines.

Small Business with Power BI and Fabric – Ep. 437

Jul 2, 2025

Small Business with Power BI and Fabric – Ep. 437

Mike and Tommy tackle a mailbag question from a small business struggling to justify Power BI and Fabric over their existing SSRS setup. They break down licensing strategies, the value of the semantic model, and why even small organizations can find the right price point for Fabric.

Deep Dive on CI/CD Branching Strategy – Ep. 436

Jun 27, 2025

Deep Dive on CI/CD Branching Strategy – Ep. 436

Mike, Tommy, and guest Mathias Thierbach unpack CI/CD branching strategies — Git Flow, GitHub Flow, GitLab Flow, and trunk-based development — exploring how they apply to Microsoft Fabric, the tooling gaps that remain, and practical advice for teams just getting started with source control.

DataOps is the Future of Power BI Teams – Ep. 435

Jun 25, 2025

DataOps is the Future of Power BI Teams – Ep. 435

Tommy, Mike, and guest Mathias Thierbach unpack what DataOps means for Power BI and Fabric teams — from source control and automated testing to scaling with junior developers. The trio debates whether AI is the key to rapid DataOps adoption and why the click-and-drag approach to Fabric projects won't survive long-term.

Top Down and Bottom Up DevOps – Ep. 434

Jun 20, 2025

Top Down and Bottom Up DevOps – Ep. 434

Mike, Tommy, and guest Matias discuss the top-down and bottom-up approaches to adopting DevOps in Power BI and Fabric teams. From convincing leadership to grassroots adoption with Git integration, they unpack practical strategies for building a DevOps culture in BI organizations.

DevOps and You, Your Team, and Your Data – Ep. 433

Jun 18, 2025

DevOps and You, Your Team, and Your Data – Ep. 433

Mike and Tommy are joined by Mathias Thierbach to unpack what DevOps really means for Power BI and Fabric teams — beyond just CI/CD. They cover why source control is the starting line, where automated testing fits (and why Microsoft tooling is still thin), plus how PBIR/PBIP and modern file formats unlock collaboration at scale.