topic Re: REPLACE(column, CHAR(160), '') unexpectedly clears entire string in Data Warehouse

REPLACE(column, CHAR(160), '') unexpectedly clears entire string

Rolandoc — Fri, 20 Jun 2025 17:19:46 GMT

We are observing critical and unexpected behavior when using the REPLACE function in Microsoft Fabric Data Warehouse. Specifically, when attempting to remove CHAR(160) (Non-Breaking Space) characters from a string column using REPLACE(YourColumn, CHAR(160), ''), the entire string value is being replaced with an empty string (''), rather than just the occurrences of CHAR(160). This behavior is inconsistent with standard T-SQL REPLACE functionality and is causing severe data corruption in our transformation pipelines.

This is Fabric DWH:

This is other Azure DWH:

Re: REPLACE(column, CHAR(160), '') unexpectedly clears entire string

lbendlin — Sat, 21 Jun 2025 13:44:17 GMT

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

Re: REPLACE(column, CHAR(160), '') unexpectedly clears entire string

V-yubandi-msft — Tue, 01 Jul 2025 05:17:47 GMT

Hi Rolandoc ,

Thank you for posting your query in the Microsoft Fabric Community. Before submitting a support ticket, it may be useful to try a simple workaround by using binary collation. This instructs the engine to compare strings byte for byte, which can help avoid issues caused by special characters like CHAR(160). Please check if this resolves the problem.

If the problem persists or you’re seeking a more permanent solution or official confirmation, as lbendlin , suggested, it’s advisable to raise a support ticket for deeper investigation.

You can also refer to the official documentation here: CHAR (Transact-SQL) - SQL Server | Microsoft Learn

— Yugandhar
Community Support Team.

Re: REPLACE(column, CHAR(160), '') unexpectedly clears entire string

V-yubandi-msft — Thu, 26 Jun 2025 13:14:05 GMT

Hi Rolandoc ,

Does the solution provided address your issue, or are you still experiencing the problem?
Your feedback is important to the community. If your issue has been resolved, please mark the response as Accepted Solution to help others find it more easily.

Thank you.

Re: REPLACE(column, CHAR(160), '') unexpectedly clears entire string

V-yubandi-msft — Tue, 01 Jul 2025 05:27:55 GMT

Hi Rolandoc ,

Just following up to see if your issue was resolved through the Microsoft support ticket. If so, it would be helpful if you could share the solution or any key points here, as it may benefit others with similar questions.
If there’s no update, we’ll plan to close this thread soon. For future questions, please feel free to start a new post in the Microsoft Fabric Community Forum. We’re here to help.

Thank you for your participation in the community.

Re: REPLACE(column, CHAR(160), '') unexpectedly clears entire string

Kanstantsin01 — Tue, 08 Jul 2025 15:30:24 GMT

Just try NCHAR instead of CHAR.