PowerBI.tips

Posts – Page 6

Page 6 of 23

DAX and Semantic Models at FabCon – Ep. 414

Apr 11, 2025

DAX and Semantic Models at FabCon – Ep. 414

Mike and Tommy break down the biggest DAX and semantic model announcements from FabCon 2025. From Direct Lake improvements to DAX calendars and user-defined functions, this episode covers what matters most for Power BI practitioners.

FabCon Rundown – Ep. 413

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

Giving People Their Data - Subscriptions? – Ep. 412

Apr 4, 2025

Giving People Their Data - Subscriptions? – Ep. 412

Mike and Tommy tackle the common request of getting report data delivered straight to users' inboxes via subscriptions. They explore the options, limitations, and best practices for giving people their data in Power BI.

Data Contracts in PBI and Fabric – Ep. 411

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

Agile and Power BI Reports – Ep. 410

Mar 28, 2025

Agile and Power BI Reports – Ep. 410

Mike and Tommy explore how Agile methodology applies to Power BI report development. They discuss iterative design, stakeholder feedback loops, and why treating reports like software projects leads to better outcomes.

Selling a Google Data Shop Power BI – Ep. 409

Mar 26, 2025

Selling a Google Data Shop Power BI – Ep. 409

Mike and Tommy tackle how to sell Power BI into an organization already invested in the Google data stack. They break down the practical challenges and strategies for fitting Power BI into a BigQuery-centric environment.

DAX Performance Testing – Ep. 408

Mar 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

Mar 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

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

Managing Multiple Datasets – Ep. 404

Mar 7, 2025

Managing Multiple Datasets – Ep. 404

Mike and Tommy tackle a mailbag question from Mehmet about best practices for managing multiple datasets in Power BI. They dive into whether composite models are the right approach for joining data across models.

Composite Models Review – Ep. 403

Mar 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

Feb 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

Feb 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

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

Dataflows Gen 1 vs Fabric SQL for Reference Tables – Ep. 399

Feb 19, 2025

Dataflows Gen 1 vs Fabric SQL for Reference Tables – Ep. 399

Mike and Tommy compare two practical ways to manage small-but-critical reference tables: Power BI Dataflows Gen1 versus a Fabric SQL database. They break down tradeoffs around refresh, governance, CI/CD, and downstream consumption so you can pick the simplest option that still scales.

Semantic Models on the Web – Ep. 398

Feb 14, 2025

Semantic Models on the Web – Ep. 398

Mike and Tommy dig into what it means for Power BI semantic models to move ‘onto the web’, from editing models directly in the service to live editing Direct Lake models from Desktop. They also connect the dots on governance, versioning, and cost—so you can adopt the new workflows without breaking your production reporting.

Semantic Link Labs Updates & Scenarios – Ep. 397

Feb 12, 2025

Semantic Link Labs Updates & Scenarios – Ep. 397

Mike and Tommy break down what’s new in Semantic Link Labs and why it’s becoming a go-to toolkit for automating Fabric and semantic model workflows with notebooks. They share practical scenarios—from incremental refresh policy updates to operational monitoring—so you can move faster while keeping governance in mind.

C# Scripting in TE vs TMDL View – Ep. 396

Feb 7, 2025

C# Scripting in TE vs TMDL View – Ep. 396

Mike and Tommy compare the classic Tabular Editor workflow—C# scripting, macros, and model metadata automation—with the newer TMDL-based experience showing up in PBIP and Power BI’s TMDL view. They break down where TMDL makes collaboration and source control dramatically better, and where Tabular Editor still earns its place in a serious semantic model toolbelt.

Fabric January 2025 Draft – Ep. 395

Feb 5, 2025

Fabric January 2025 Draft – Ep. 395

Mike and Tommy walk through their ‘draft’ of the Microsoft Fabric January 2025 update, calling out the changes they think will matter most for Power BI and Fabric practitioners. From TMDL scripting and semantic model version history to Copilot/Q&A improvements and OneLake catalog metadata, this episode helps you prioritize what to test next.

Microsoft Fabric Job Listings – Ep. 394

Jan 31, 2025

Microsoft Fabric Job Listings – Ep. 394

In this episode, Mike and Tommy unpack a mailbag question: why are there still so few job listings that explicitly ask for Microsoft Fabric? They break down what’s really happening in the market today and how both job seekers and hiring managers should think about Fabric skills as adoption ramps up.

How to Use Copilot Capacity – Ep. 393

Jan 29, 2025

How to Use Copilot Capacity – Ep. 393

Mike and Tommy break down what Copilot Capacity is and how to think about sizing and governance so your organization can safely roll out Copilot features in Power BI. They share practical guidance for planning adoption, controlling cost, and setting expectations as teams move from experimentation to production.

Fabric Too Simple or Too Complex? – Ep. 392

Jan 24, 2025

Fabric Too Simple or Too Complex? – Ep. 392

In this episode, Mike and Tommy wrestle with a question they keep hearing: is Microsoft Fabric too complex or too simple, depending on who’s using it? They also dig into the ‘myth of the data catalog’ and why getting clear on definitions and outcomes matters more than buying another tool.

Using Only Bronze? – Ep. 391

Jan 22, 2025

Using Only Bronze? – Ep. 391

Mike and Tommy tackle a common Fabric design question: can you ship analytics by building only a Bronze layer, or do you really need Silver and Gold. They break down what you gain (and lose) when you skip refinement layers, and share practical rules of thumb for keeping models trustworthy, performant, and maintainable.