Help Needed: Error Merging Text Columns in Power BI

Hello Power BI Community,

I've encountered a perplexing issue in Power BI Desktop and could use some guidance. I am attempting to merge two tables based on text columns, but despite both columns being of type Text, the operation fails with an error indicating a type mismatch.

Here are the steps I've taken and relevant details:

Objective: Merge Table1 and Table2 using the "contractNumber" column from both tables to combine related records.

Data Types: Confirmed both "contractNumber" columns in Table1 and Table2 are of type Text.

Join Type: Using an Inner Join as it suits my requirement to match records present in both tables.

Error Message: "Expression.Error: Désolé... Nous n'avons pas pu convertir la valeur '[Record]' en type Record. Détails: Value=[Record] Type=[Type]"

Troubleshooting Steps Already Attempted:

Checked for hidden or non-printable characters using Text.Trim and Text.Clean functions.

Ensured case consistency by converting both columns to lowercase.

Refreshed data in Power BI to ensure all changes were applied.

Manually inspected the data for anomalies.

Attempted to recreate the merge step with the same configurations.

Despite these efforts, the merge operation continues to fail. I have not encountered this issue before and have successfully performed similar merges in the past.

Complementary information:

The error only applies to PBIX file, the online service still manages to update daily. Nothing has changed in the semantic model, it just started occurring out of the blue.

Questions:

Has anyone experienced a similar issue or have any insights on what might be causing this error?

Are there any additional troubleshooting steps or alternative approaches you would recommend?

Could this issue be related to a recent update or is there a known bug in the current Power BI version (2.127.1235.0)?

I appreciate any advice or guidance you can provide. Thank you for your help!

Best regards,