PowerBI.tips

Posts – Page 15

Page 15 of 25

SQL or OneLake – Ep. 236

Jul 28, 2023

SQL or OneLake – Ep. 236

Ep. 236 breaks down the Fabric ‘SQL vs OneLake’ decision: what’s just different interfaces over the same Delta storage, where governance and permissions still matter, and how to keep architectures understandable as the platform converges.

The Root of All Problems – Ep. 235

Jul 26, 2023

The Root of All Problems – Ep. 235

Ep. 235 is a practical episode for anyone stuck in ‘fix the dashboard’ mode: it shows how to trace undesirable effects back to real root causes using a systems mindset. You’ll also learn what Chris Webb’s Fabric tests reveal about Direct Lake ‘data hotness’, capacity limits, and why some queries can quietly fall back to DirectQuery.

The Perfect Data Analyst – Ep. 234

Jul 21, 2023

The Perfect Data Analyst – Ep. 234

Ep. 234 breaks down what makes a ‘perfect’ data analyst: not just technical ability, but the communication and business context needed to turn messy questions into decisions. The team also uses Fabric’s data-integration options (pipelines, Dataflow Gen2, notebooks) to talk through tradeoffs, missing ‘table stakes’ features, and what lock-in really means while the platform is still maturing.

Too Many Details? – Ep. 233

Jul 19, 2023

Too Many Details? – Ep. 233

In Ep. 233, the crew answers a mailbag question on how much detail belongs in a Power BI report—covering model grain, drillthrough patterns, and ways to keep users in flow without turning VertiPaq into a row-level warehouse.

Symbiotic Relationship of Data – Ep. 232

Jul 14, 2023

Symbiotic Relationship of Data – Ep. 232

In Ep. 232, Mike, Tommy, and Seth break down the symbiotic relationship between data governance and data storytelling—why trust, ownership, and clear lineage are what turn dashboards into decisions.

What is a Data Model? – Ep. 231

Jul 12, 2023

What is a Data Model? – Ep. 231

In Ep. 231, Mike, Tommy, and Seth unpack what a “data model” actually is and why it matters—from conceptual diagrams to logical fields and finally the physical star schema you build in Power BI. You’ll learn how clearer modeling conversations reduce DAX complexity, improve trust, and set teams up for scalable, reusable reporting.

Domain Roles Part 2 – Ep. 230

Jul 7, 2023

Domain Roles Part 2 – Ep. 230

In Ep. 230, Mike, Tommy, and Seth continue their domain roles series and map out how responsibilities shift as you move from Power BI into Microsoft Fabric. You'll learn practical ways to define ownership, reduce duplication, and build trust using clear governance and promotion/certification patterns.

PBI Domains – Ep. 229

Jul 5, 2023

PBI Domains – Ep. 229

In Ep. 229, Mike, Tommy, and Seth break down Fabric domains and why they’re only useful when paired with clear ownership and process. They debate central BI vs. business-led models, workspace roles, and the promotion/certification path needed to keep Fabric enablement from turning into chaos.

PBIP – Ep. 228

Jun 30, 2023

PBIP – Ep. 228

In Ep. 228, Mike, Tommy, and Seth break down PBIP (the Power BI Project format) and what it unlocks for real Git workflows: diffs, pull requests, and repeatable CI/CD. They also discuss Fabric Git integration and why preview features still demand cost and governance discipline.

Data Governance & Adoption – Ep. 227

Jun 28, 2023

Data Governance & Adoption – Ep. 227

In Ep. 227, Mike, Tommy, and Seth explore what Fabric adoption really requires: governance, ownership, and cost visibility—not just new tech. They debate OneLake discoverability and the ‘lakehouse per dataset’ question, then land on a practical distinction: data quality is the condition of your data, while data governance is the operating model that keeps it trustworthy.

Fabric Capacities – Ep. 226

Jun 23, 2023

Fabric Capacities – Ep. 226

In Ep. 226, Mike, Tommy, and Seth unpack Microsoft Fabric capacities with a cost-first lens: how to read CU consumption, what ‘hidden’ background artifacts can imply for spend, and which controls (like pausing a capacity) help you experiment without getting surprised.

RIP Workspaces – Ep. 225

Jun 21, 2023

RIP Workspaces – Ep. 225

In Ep. 225, Mike, Tommy, and Seth unpack why ‘workspaces’ are getting noisier in the Fabric era: new item types that appear automatically, what should be hidden vs. governed, and the simple standards that keep teams productive while the platform shifts under your feet.

Fabric Decision Guide – Ep. 224

Jun 16, 2023

Fabric Decision Guide – Ep. 224

In Ep. 224, Mike, Tommy, and Seth use Microsoft’s Fabric Decision Guide to clarify when a warehouse-first approach makes sense versus a lakehouse-first approach—and how to pick a default pattern your team can govern consistently.

Data Ingestion Part 2 – Ep. 223

Jun 14, 2023

Data Ingestion Part 2 – Ep. 223

In Ep. 223, Mike, Tommy, and Seth continue the data ingestion series with a pragmatic Fabric lens: when to use pipelines vs. dataflows vs. Spark, what tradeoffs actually matter, and how to standardize ingestion so it’s scalable, governable, and maintainable.

Fabric Decision Guide – Ep. 222

Jun 9, 2023

Fabric Decision Guide – Ep. 222

In Ep. 222, Mike, Tommy, and Seth use Microsoft’s Fabric Decision Guides to pick practical defaults for ingestion and storage—and explain how to govern those choices so teams stop reinventing the platform on every project.

Exploring Direct Lake and One Lake – Ep. 221

Jun 7, 2023

Exploring Direct Lake and One Lake – Ep. 221

In Ep. 221, Mike, Tommy, and Seth break down OneLake and Direct Lake in Microsoft Fabric—what they are, how they work together, and where the sharp edges still are. If you’re trying to pick a durable lakehouse pattern, this episode gives you the mental model for shortcuts, security, and performance before you bet your architecture on the new stack.

GIT & Power BI – Ep. 220

Jun 2, 2023

GIT & Power BI – Ep. 220

In Ep. 220, Mike, Tommy, and Seth break down Git integration for Power BI in Microsoft Fabric—what version control changes for BI teams, how branches and pull requests map to report development, and the simplest way to start adopting source control without slowing delivery.

New Buttons in PBI – Ep. 219

May 31, 2023

New Buttons in PBI – Ep. 219

Ep. 219 is all about Power BI’s evolving button experience—especially navigators and slicer apply/clear patterns—and how a few small UX choices can make reports easier to understand, faster to use, and harder to break by accident.

Hello Microsoft Fabric – Ep. 218

May 26, 2023

Hello Microsoft Fabric – Ep. 218

Ep. 218 is a high-energy breakdown of Microsoft Fabric—why it feels like the next evolution of the Power BI platform, and the governance, capacity, and admin decisions you should consider before enabling it broadly.

PQ Functions – Ep. 217

May 24, 2023

PQ Functions – Ep. 217

Ep. 217 is a practical conversation about Power Query functions—how to build a small library of repeatable helpers, where reuse breaks down inside PBIX files, and when it’s time to move transformations into shared dataflows or upstream pipelines.

Learning Python – Ep. 216

May 19, 2023

Learning Python – Ep. 216

Ep. 216 explores where Python fits in the modern Power BI skill stack—why notebooks are creeping into BI workflows, when SQL and DAX still matter more, and practical ways to start learning without derailing your day job.

Visual Enhancements Updates – Ep. 215

May 17, 2023

Visual Enhancements Updates – Ep. 215

Ep. 215 dives into the March 2023 visual container upgrades—subtitle, divider, and padding—and how they unlock cleaner report layouts. The team also explores viewing PBIX reports directly from SharePoint/OneDrive and what it means for versioning and governance.