Category: Power Query

Clean Data with Copilot in Excel – What Works and What Doesn’t? Episode 2673

Posted on by Annie D

Microsoft Excel Tutorial: Excel Clean Data with Copilot

Microsoft Excel just introduced the Clean Data feature in Win32, bringing AI-powered data cleaning straight to the desktop! This tool, previously available in Excel Online since October 2024, promises to detect and fix inconsistencies in your dataset—like inconsistent text, formatting issues, and more. But does it really work as expected?

In this episode, I put Clean Data to the test with a variety of messy datasets. It does well in some areas, like recognizing spelling variations and fixing number formats. However, it struggles with company name inconsistencies, date issues, and partial data cleaning—sometimes catching Continue reading “Clean Data with Copilot in Excel – What Works and What Doesn’t? Episode 2673” →

Conquer Circular Dependencies: Sort Months Effortlessly in Power BI

Posted on by Annie D

Are month-sorting errors driving you mad? In this video, Patrick lifts the curtain on why your semantic model keeps throwing that frustrating circular dependency error. Watch step by step as he reveals the fix—plus a game-changing tip on heading off these issues upstream in Power Query or even at the data source. It’s time to banish those Power BI sorting nightmares and reclaim your data sanity once and for all!

Demo File:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/PBIX/2025/20250227%20-%20Month%20will%20not%20sort.zip

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “Conquer Circular Dependencies: Sort Months Effortlessly in Power BI” →

How I Fixed 1000+ Power BI Comments in ONE Day!

Posted on by Annie D

Join Patrick as he shares how he tackled some Power BI questions! These honestly answer thousands of questions we get every day. Following best practices solves so many head-aches!

Demo files:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/PBIX/2025/20250226%20-%20Star%20Schema.zip

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools Continue reading “How I Fixed 1000+ Power BI Comments in ONE Day!” →

Multiple Fact Tables in Power BI Made Simple and FAST!

Posted on by Annie D

We got a question about circular dependencies based on a previous video Patrick did. So, how do you handle that with multiple fact tables in Power BI? Patrick breaks it down!

Understanding circular dependencies in DAX
https://www.sqlbi.com/articles/understanding-circular-dependencies/

Avoiding circular dependency errors in DAX
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

Sample files:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/PBIX/2025/20250220%20-%20Multiple%20Facts.zip

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— <a href="http://twitter.com/patrickdba" target="_blank" Continue reading “Multiple Fact Tables in Power BI Made Simple and FAST!” →

How to Make Your PowerPoint Presentations 10X More Powerful?

Posted on by Annie D

Want to make your PowerPoint presentations 10X more powerful??? Patrick goes through new capabilities with embedding a Power BI report to make your slides interactive and more engaging!

Add live Power BI data to PowerPoint
https://learn.microsoft.com/power-bi/collaborate-share/service-power-bi-powerpoint-add-in-install

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Continue reading “How to Make Your PowerPoint Presentations 10X More Powerful?” →

Your Connections are a MESS! Let’s clean it up…

Posted on by Annie D

Have you ever looked at the Connections area in Microsoft Fabric? Even all the Power BI folks should look at this! It can get out of control. Patrick shows how he approaches the chaos of connections.

Data source management
https://learn.microsoft.com/fabric/data-factory/data-source-management

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— Continue reading “Your Connections are a MESS! Let’s clean it up…” →

Upgrade to a free Microsoft Fabric Trial? I already have capacity!

Posted on by Annie D

I wanted to start using some of the new Preview features in Microsoft Fabric when I got a message saying I needed to “Upgrade to a free Microsoft Fabric Trial”. Huh??? I already have the workspace in a Capacity! Adam explains what might be happening.

Create a SQL database in the Fabric portal
https://learn.microsoft.com/fabric/database/sql/create

Create an AI skill (preview)
https://learn.microsoft.com/fabric/data-science/how-to-create-ai-skill

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: <a href="https://guyinacu.be/courses" target="_blank" Continue reading “Upgrade to a free Microsoft Fabric Trial? I already have capacity!” →

Excel Three Bots Versus Three Gurus Episode 2672

Posted on by Annie D

Microsoft Excel Tutorial: Solving a Text Comparison Problem: 3 AI Bots versus 3 Humans.

To download the workbook from today: https://www.mrexcel.com/youtube/GPLLrcq3D3A/

The battle is on! In Episode 2672, we’re pitting three AI bots (Deep Seek, Copilot, and Beta Copilot with Python) against three (and a half) human Excel gurus (Rico, XLLambda, and Geert). Who will come up with the best solution for an Excel text comparison problem?

This challenge comes from Brian, who wanted to compare two text strings and extract the differences. Seems simple, right? Well, not quite! My initial formula had some issues, so I turned to Continue reading “Excel Three Bots Versus Three Gurus Episode 2672” →

Excel Copilot Versus Deep Seek Head to Head – Episode 2671

Posted on by Annie D

Microsoft Excel Tutorial: Deep Seek vs. Copilot: Head-to-Head Excel Formula Challenge!

Welcome to Learn Excel from MrExcel Podcast, Episode 2671! Today, we’re putting two AI-powered assistants to the test—Deep Seek vs. Copilot—to see which one performs better in Excel formula creation and formula explanation. Who will come out on top? Stick around to find out!

Test #1: Formula Creation

I started with a simple yet classic Excel challenge: detecting prime numbers in a column of integers. Deep Seek provided both a helper column approach and a single-cell array formula, while Copilot struggled due to the requirement for Auto Save to be turned on. Continue reading “Excel Copilot Versus Deep Seek Head to Head – Episode 2671” →

Mirror or Shortcut with Azure Databricks in Microsoft Fabric? YES!!!

Posted on by Annie D

Using Azure Databricks? Confused if you should just use a shortcut or mirror it? Perhaps the answer is YES! Patrick shows you the benefits of using the mirroring capability with Azure Databricks.

Mirroring Azure Databricks Unity Catalog (Preview)
https://learn.microsoft.com/fabric/database/mirrored-database/azure-databricks

Tutorial: Configure Microsoft Fabric mirrored databases from Azure Databricks (Preview)
https://learn.microsoft.com/fabric/database/mirrored-database/azure-databricks-tutorial

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— <a Continue reading “Mirror or Shortcut with Azure Databricks in Microsoft Fabric? YES!!!” →

Excel The Mysterious Chart Label That Wouldn’t Update – Solved! – Episode 2670

Posted on by Annie D

Microsoft Excel Tutorial: The Mysterious Chart Label That Wouldn’t Update – Solved!

A completely evil Excel problem! A chart label refuses to update, no matter what you do. My friend Kelly sent me this chart, and everything seemed fine—except for one stubborn label that always says “Test 1.” Even after checking that the labels are correctly linked to a range using “Value From Cells,” this one label remains broken. After trying everything, I had to reach out to someone on the Excel team, and they finally gave me the answer.

Turns out, the label became disconnected from the data, and there’s a Continue reading “Excel The Mysterious Chart Label That Wouldn’t Update – Solved! – Episode 2670” →

Excel Change 3D Map From City To State – Episode 2669

Posted on by Annie D

Microsoft Excel Tutorial: Use 3D Maps to summarize city data at the state level.

Got sales data by city but need to display it by state in Excel’s 3D Maps? A.K. asked if there’s a way to sum sales at the state level instead of individual cities—yes, and it’s easy to do! In this tutorial, I’ll walk you through the steps to modify your 3D Map to show sales totals by state.

By default, Excel’s 3D Map plots data at the city level. If you want to switch to state-level mapping, simply adjust the location field to use State instead of Continue reading “Excel Change 3D Map From City To State – Episode 2669” →