Can't add field from relationshipped table to sheet when filter on field in the other table is applied

An error occurred while communicating with the Microsoft SQL Server data source 'Peer_Users+ (Multiple Connections)'

Error Code: 2F0F5E42

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_Pref_CP1_CI_AS" in the equal to operation.

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared.

I was thinking there are multiple different possibilities as to why this is happening, but I'm not sure how to fix it.