Collate in Power Query M?

I'm specifically trying to merge 2 tables but get a collation error. I want to resolve this error specifically in Power Query M. Not BI or SQL or anything.

Table 1 is my primary table with dozens of different columns - one of which is the Customer ID Number

Table 2 is dedicated to details of each customer ID number (Name, address, etc.)

I'm trying to merge the 2 on the Customer ID Number column, which works fine, but when I expand afterwards, I get the following collation error:

DataSource.Error: Microsoft SQL: Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Details:
DataSourceKind=SQLDataSourcePath=REDACTED;Database Name
Message=Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Number=468
Class=16

I just want to know if it's possible to collate in M specifically.