PowerBI.tips

Tag

#Microsoft Fabric

67 posts

AI-Assisted TMDL Workflow & Hot Reload – Ep. 507

March 4, 2026

AI-Assisted TMDL Workflow & Hot Reload – Ep. 507

Mike and Tommy explore AI-assisted TMDL workflows and the hot reload experience for faster Power BI development. They also cover the new programmatic Power Query API and the GA release of the input slicer.

Filter Overload – Ep. 506

February 27, 2026

Filter Overload – Ep. 506

Mike and Tommy dive into the February 2026 feature updates for Power BI and Fabric, with a deep focus on the new input slicer going GA and what it means for report filtering. The conversation gets into filter overload — when too many slicers and options hurt more than they help.

Living in a Direct Lake World – Ep. 504

February 20, 2026

Living in a Direct Lake World – Ep. 504

Mike and Tommy dive deep into what it means to live in a Direct Lake world, exploring the practical realities of building semantic models on top of Fabric lakehouses. They cover the trade-offs, gotchas, and best practices for teams making the shift from Import mode to Direct Lake.

Hiring the Report Developer – Ep. 503

February 18, 2026

Hiring the Report Developer – Ep. 503

Mike and Tommy unpack what a report developer should know in 2026 — from paginated reports and the SSRS migration trend to the line between report building and data modeling.

Trusting In Microsoft Fabric – Ep. 502

February 13, 2026

Trusting In Microsoft Fabric – Ep. 502

Mike and Tommy dive deep into whether Microsoft Fabric has earned our trust after two years. Plus, the SaaS apocalypse is here, AI intensifies work, and Semantic Link goes GA.

Being a Data Analyst in the Era of AI

February 4, 2026

Being a Data Analyst in the Era of AI

Mike Carlo and Eugene Meidinger discuss how AI is reshaping the data analyst's toolkit with practical frameworks for adopting AI in your daily workflow.

Do You Really Need Fabric? – Ep. 495

January 21, 2026

Do You Really Need Fabric? – Ep. 495

Mike and Tommy unpack a viral LinkedIn article where a consultant saved a client $57,000 per year by moving from Fabric F64 to Premium Per User — sparking a bigger conversation about when Fabric actually makes sense, licensing confusion, and the tipping points that justify the investment.

MCP Your Fabric Data – Ep. 494

January 16, 2026

MCP Your Fabric Data – Ep. 494

Mike and Tommy unpack Model Context Protocol (MCP) servers for Power BI and Fabric — what they are, how to use them, and whether organizations should be turning them on today. Plus, a deep dive on what makes AI agents actually useful versus just impressive.

AI Drives Fabric Success – Ep. 493

January 14, 2026

AI Drives Fabric Success – Ep. 493

Mike and Tommy kick off 2026 asking the big question: will AI drive Fabric's success? They share their real AI toolkits, debate the future of consulting in an agent-powered world, and brainstorm how Claude Code and agent skills could transform their daily workflows.

Fabric Awards – Ep. 492

January 9, 2026

Fabric Awards – Ep. 492

Mike and Tommy hand out their completely made-up Fabric Awards for 2025 — from 'Most Likely to Be Disabled by IT' to 'This Is Why We Can't Have Nice Things.' Plus, Marco Russo confirms what they've been saying all along: notebooks win.

Our Fabric Resolutions – Ep. 491

January 7, 2026

Our Fabric Resolutions – Ep. 491

Mike and Tommy share their 2026 Fabric resolutions — from doubling down on Power BI embedding and data warehouses to validating AI-generated code and building custom workloads. Plus, Microsoft acquires Osmos to bring agentic AI to Fabric data engineering.

Revisiting Dataflows Gen 2 – Ep. 490

January 2, 2026

Revisiting Dataflows Gen 2 – Ep. 490

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.

Power BI Secret Santa – Ep. 488

December 26, 2025

Power BI Secret Santa – Ep. 488

Mike and Tommy exchange Power BI and Fabric feature wishlists in a holiday Secret Santa format, proposing everything from sticky notebook cells to integrated Python notebooks in desktop. A fun Christmas special packed with product ideas that could reshape the developer experience.

The Intelligence Developer – Ep. 487

December 24, 2025

The Intelligence Developer – Ep. 487

Mike and Tommy explore the emerging 'Intelligence Developer' role—a new position shaped by AI and Fabric IQ that shifts focus from metrics to dimensions and data governance. They also recap the biggest SQL, Fabric, and Power BI developments of 2025.

1-Click Notebooks – Ep. 485

December 17, 2025

1-Click Notebooks – Ep. 485

Mike and Tommy explore the new 1-click notebook experience for Power BI semantic models, including Semantic Link integration and what it means for BI developers moving into Python and Spark workflows. Plus, how Fabric's forecasting service makes Spark notebooks feel instant.

Untangling Workspace, Branching, and Artifact Chaos – Ep. 478

November 21, 2025

Untangling Workspace, Branching, and Artifact Chaos – Ep. 478

Mike and Tommy tackle one of Fabric's most confusing topics: how to design and manage workspaces when you're juggling branching, deployment pipelines, and a growing number of artifacts. They share patterns that work and anti-patterns that create chaos.

Start with the Why – Ep. 477

November 19, 2025

Start with the Why – Ep. 477

Another mailbag episode where Mike and Tommy emphasize the most important question in any data project: what problem are you actually trying to solve? Before picking tools, building pipelines, or designing models—start with the why.

Data Modeling in Event Driven Architectures – Ep. 471

October 29, 2025

Data Modeling in Event Driven Architectures – Ep. 471

Mike and Tommy explore how data modeling changes when your source data comes from event-driven systems rather than traditional transactional databases. They discuss the shift from state-based to event-based thinking and what it means for semantic models.

What Is Real-Time Intelligence? – Ep. 467

October 15, 2025

What Is Real-Time Intelligence? – Ep. 467

Mike and Tommy take a deep dive into Fabric's Real-Time Intelligence workload—what it is, how Eventhouses work, and why it represents a paradigm shift from batch analytics to event-driven decision making. Plus, metric sets deprecation and OneLake Table APIs.

Data Agents and Semantic Models – Ep. 466

October 10, 2025

Data Agents and Semantic Models – Ep. 466

Mike and Tommy explore the intersection of Data Agents and semantic models—how well-built models become the foundation for AI-powered data experiences, and what best practices look like for configuring agents that actually deliver useful answers.

Is Microsoft Fabric Business Intelligence? – Ep. 464

October 3, 2025

Is Microsoft Fabric Business Intelligence? – Ep. 464

Mike and Tommy tackle the identity question: is Fabric a BI platform, a data engineering platform, or something else entirely? They discuss where Power BI fits in the bigger Fabric picture and whether BI professionals need to expand their skill sets. Plus, Copy Job and Dataflow Gen2 updates.

Microsoft Fabric Feature Pyramid – Ep. 462

September 26, 2025

Microsoft Fabric Feature Pyramid – Ep. 462

Mike and Tommy rank Fabric features in a pyramid format—from the single most essential feature at the top to the supporting cast at the base. A fun exercise that reveals what they think matters most in the Fabric ecosystem right now.

Fabcon Vienna – Ep. 461

September 24, 2025

Fabcon Vienna – Ep. 461

Mike and Tommy recap FabCon Vienna—the big announcements, the September Fabric feature summary, the new extensibility toolkit, and calendar-based time intelligence. A packed episode covering the European conference highlights.

Composite Models vs Reusable Datasets – Ep. 460

September 19, 2025

Composite Models vs Reusable Datasets – Ep. 460

Mike and Tommy compare composite models and reusable datasets—two approaches to sharing and extending semantic models across teams. They also react to Translytical Task Flows from listener feedback in their 'Beat from the Street' segment.

Initial Impressions of Data Agents – Ep. 459

September 17, 2025

Initial Impressions of Data Agents – Ep. 459

Mike and Tommy share first impressions of Fabric Data Agents—what's promising, what's still hype, and how multi-agent orchestration with Copilot Studio fits in. Plus, smarter agent instructions and a Chicago Fabric crash course meetup.

Planning Your Capacity – Ep. 457

September 12, 2025

Planning Your Capacity – Ep. 457

Mike and Tommy tackle one of the most common Fabric questions: how do you plan and size your capacity? They walk through Microsoft's capacity planning tools, estimator, and optimization strategies to help teams right-size their Fabric investment.

The Fabric Magic Wand – Ep. 458

September 12, 2025

The Fabric Magic Wand – Ep. 458

If you had a magic wand and could add any feature to Fabric, what would it be? Mike and Tommy riff on Stephanie Bruno's LinkedIn post about dream Fabric features, sharing their own wish lists and debating what would have the biggest impact.

Looking at the Warehouse Roadmap – Ep. 454

August 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

August 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.

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

August 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

August 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

August 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.

Fabric June 2025 Feature Draft – Ep. 439

July 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

July 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

July 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

June 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

June 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.

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

June 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.

Build for AI or Build for Reports? – Ep. 430

June 6, 2025

Build for AI or Build for Reports? – Ep. 430

Mike and Tommy debate whether your next investment of time should go toward making reports better or making your semantic model AI-ready. They unpack Microsoft's new 'Prep Data for AI' features — AI instructions, AI data schema, and verified answers — and ask the hard question: is the juice worth the squeeze?

Shortcut Mania! Use Cases for Shortcuts – Ep. 429

June 4, 2025

Shortcut Mania! Use Cases for Shortcuts – Ep. 429

Mike and Tommy dive deep into Microsoft Fabric shortcuts — from managing connections and creating shortcuts programmatically to using them as data contracts between teams. They explore how shortcuts are changing data architecture patterns and enabling new ways to distribute and govern data across organizations.

Adopting Copilot Standalone for Power BI – Ep. 428

May 30, 2025

Adopting Copilot Standalone for Power BI – Ep. 428

Mike and Tommy break down what Copilot Standalone for Power BI is and why it changes the consumer experience for chat-with-your-data. Then they role-play a realistic rollout plan—starting with real problems, measurable wins, and AI-ready semantic models instead of a blanket mandate.

What Microsoft Build Means For You – Ep. 427

May 28, 2025

What Microsoft Build Means For You – Ep. 427

Mike and Tommy unpack Microsoft Build 2025 announcements through a practical lens — from open mirroring and SQL database tooling to the new standalone Copilot for Power BI. The main topic: a role-play exercise on how you'd actually roll out Copilot standalone in your organization.

Are We Still Self Service Or Drifting Back to Corporate BI – Ep. 425

May 20, 2025

Are We Still Self Service Or Drifting Back to Corporate BI – Ep. 425

Mike and Tommy debate whether the Power BI and Fabric ecosystem is still truly self-service or quietly drifting back toward corporate BI, exploring semantic model-to-lakehouse sync, data contracts, managed self-service, and where the line between central IT and business users really falls.

Uses for TMDL & VS Code – Ep. 424

May 16, 2025

Uses for TMDL & VS Code – Ep. 424

Mike and Tommy unpack TMDL — the Tabular Model Definition Language — tracing its origins from the monolithic BIM file to today's human-readable, file-per-object format. They explore practical use cases in VS Code, from find-and-replace renaming to AI-powered measure descriptions and unused-object cleanup with GitHub Copilot.

Tools in Power BI – Ep. 423

May 14, 2025

Tools in Power BI – Ep. 423

Mike and Tommy dive into the rich ecosystem of third-party and first-party tools that help Power BI developers build, test, deploy, and optimize their models and reports. From SQLBI's comprehensive overview to hands-on favorites, this episode is a toolbox tour for every Power BI practitioner.

Max Performance in Power Query – Ep. 422

May 9, 2025

Max Performance in Power Query – Ep. 422

Mike, Tommy, and special guest Alex Powers deep-dive into squeezing maximum performance out of Power Query—from Excel origins to Dataflows Gen 2 in Fabric. They cover staging defaults, V-Order optimization, query folding, the ELT mindset shift, and why copy-pasting Gen 1 code into Gen 2 will burn your CU budget.

Half Baked Ideas – Ep. 420

May 2, 2025

Half Baked Ideas – Ep. 420

Mike and Tommy serve up their half baked ideas for the Power BI and Fabric ecosystem. From wish-list features to wild predictions, this episode is all about thinking out loud.

Do we Design Lakehouse Differently Now? – Ep. 419

April 30, 2025

Do we Design Lakehouse Differently Now? – Ep. 419

Mike and Tommy explore whether recent Fabric updates change how we should design a lakehouse architecture. With Direct Lake now available in Power BI Desktop and new workspace item limits, the design conversation is shifting fast.

Education for a Data Scientist in the Age of Fabric? – Ep. 418

April 25, 2025

Education for a Data Scientist in the Age of Fabric? – Ep. 418

Mike, Tommy, and guest Ginger Grant explore what education for a data scientist should look like in the age of Microsoft Fabric. They discuss whether traditional college degrees still hold up, the value of internships, and how the evolving data platform landscape is reshaping what skills matter most.

Should Data Scientists Care about PBI? – Ep. 416

April 18, 2025

Should Data Scientists Care about PBI? – Ep. 416

Mike and Tommy tackle whether data scientists should pay attention to Power BI, featuring a lively discussion on the intersection of data science and business intelligence. Plus, news on Fabric User Data Functions and VS Code custom instructions for Copilot.

FabCon Rundown – Ep. 413

April 9, 2025

FabCon Rundown – Ep. 413

Mike and Tommy break down the biggest announcements from FabCon 2025, covering agentic AI capabilities, new warehouse functions, and metadata-driven lakehouse patterns. They also spotlight the Power Designer Workload and Entelexos for Power BI Embedded.

Data Contracts in PBI and Fabric – Ep. 411

April 2, 2025

Data Contracts in PBI and Fabric – Ep. 411

Mike and Tommy dive into data contracts and how they apply to Power BI and Microsoft Fabric environments. They explore why formalizing expectations between data producers and consumers is key to building trustworthy, scalable data platforms.

DAX Performance Testing – Ep. 408

March 21, 2025

DAX Performance Testing – Ep. 408

Mike and Tommy dive into the new DAX Performance Testing notebook from Microsoft's Fabric Toolbox, a powerful open-source tool for automating query benchmarks across cold, warm, and hot cache states. They also cover the latest Tabular Editor releases and code actions features.

Investing $100 in Fabric and Power BI – Ep. 406

March 14, 2025

Investing $100 in Fabric and Power BI – Ep. 406

Mike and Tommy explore what you can accomplish with just $100 invested in Microsoft Fabric and Power BI. They also check out PowerTable's new private preview for building data apps on modern data platforms.

Naming Conventions – Ep. 405

March 12, 2025

Naming Conventions – Ep. 405

Mike and Tommy dive into naming conventions for Microsoft Fabric items and why a consistent structure matters as your workspace grows. Plus, news on AI functions in Fabric and the February 2025 feature summary.

Composite Models Review – Ep. 403

March 5, 2025

Composite Models Review – Ep. 403

Mike and Tommy dive deep into composite models in Power BI, reviewing how they work and when to use them. They also cover the new Spark connector for Fabric Data Warehouse now in public preview.

Journey of a Citizen Developer – Ep. 402

February 28, 2025

Journey of a Citizen Developer – Ep. 402

Mike and Tommy reflect on the journey of a citizen developer growing with Power BI. They share practical advice on leveling up from self-taught report builder to trusted data professional.

SQL Databases - What, Why, How? – Ep. 401

February 26, 2025

SQL Databases - What, Why, How? – Ep. 401

Mike and Tommy dive deep into SQL databases in Microsoft Fabric — what they are, why they matter, and how to get started. They also cover the new Fabric Quotas feature and debate which social media platform they'd keep if they could only have one.

Choose a Data Store - Fabric Decision Guide – Ep. 400

February 21, 2025

Choose a Data Store - Fabric Decision Guide – Ep. 400

Mike and Tommy celebrate episode 400 and dive into the Microsoft Fabric decision guide for choosing the right data store. They break down when to use a lakehouse, warehouse, eventhouse, SQL database, and more — helping you pick the right tool for the job.

← All Tags