Results 1 to 2 of 2

Thread: Collate in Power Query M?

  1. #1
    Neophyte GigaFluxx's Avatar
    Join Date
    May 2020
    Posts
    1
    Articles
    0
    Excel Version
    365

    Question Collate in Power Query M?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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=SQL
    DataSourcePath=REDACTED;DatabaseName
    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.

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,834
    Articles
    0
    Excel Version
    O365
    Can you pass the workbook, thge explanation is too vague to work with.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •