When is a space not a space?  When Power Query Clean Fails. @AccessAnalyticLearn
When is a space not a space?  When Power Query Clean Fails.  @AccessAnalyticLearn
Uploaded February 2025 | Updated November 2026, 1 day ago
Have you ever encountered an Excel dataset where spaces don’t behave like spaces? In this lesson, we explore an issue where seemingly identical text values don’t get recognized as duplicates—even after using Text.Clean or Power Query’s Remove Duplicates feature! We uncover the mystery behind non-breaking spaces and hidden characters that can cause unexpected issues in your data. With the help of MVP experts, we demonstrate step-by-step how to detect and remove these tricky characters using Power Query’s Replace Values and delimiter splitting techniques. By the end of this tutorial, you’ll have the tools to ensure your datasets are truly clean!

Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join

The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/

Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/


Connect with me
wyn.bio.link
When is a space not a space?  When Power Query Clean Fails.Messy data ruins everything before you even startFaster SharePoint folder consolidation using Incremental Refresh (see warning in the notes)Excel Drop Down Asterisk HackWho cares about data validation?Excel or Power BI?How good is Copilot at Power Query ?Power Query Convert Columns to Rows for groups and expand columns dynamically in 2 waysAre you a 7?💥 NEW Power BI + PowerPoint Integration: Full Demo & Tutorial!How to prevent a hidden Power BI page being printedHow to get 6 million views on YouTube [satire]
Access Analytic Learn |

When is a space not a space? When Power Query Clean Fails.

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER