PowerBI.tips

Posts – Page 6

Page 6 of 24

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.

Power Query, Skills to Know and Learn – Ep. 421

May 7, 2025

Power Query, Skills to Know and Learn – Ep. 421

Mike and Tommy dive into the Power Query skills every Power BI user should master. From essential daily transforms to advanced M language techniques, they break down what to learn first and what to tackle as you level up.

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

Apr 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

Apr 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

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

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.