Forum Discussion
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...
Try adding an index column to one or both tables before the merge.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Try adding an index column to one or both tables before the merge.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Very interesting, why does that work? Will the table I added the index column to still pull in new data upon refresh or does adding the Index column make it static?
hey Adding an index column worked for me. Thanks!
