Forum Discussion

WNCPBI's avatar
WNCPBI
Frequent Visitor
2 years ago
Solved

Dataflow refresh failing on Merged table (Cannot resolve the collation conflict)

I am importing an Excel workbook into a PPU Workspace Dataflow.   From the table, I've created a star schema with four dimension tables and a fact table. Three of the Dimension tables are creating ...
Need Help
  • WNCPBI's avatar
    WNCPBI
    2 years ago

    Thanks for the reply. I thought that might be the issue too, but setting the locale on the affected columns didn't work either.  I have found that setting the "Enhanced Compute Engine" to Disabled for the dataflow does resolve the issue. Whether this will have any unintended consequences through, I'm not sure, but for now it resolves the issue.

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

There is an option labeled "Using Locale" when you right click on a column header in Power Query. I would go through each of the columns in your tables and choose that option to update your data types. You have two different "locales" somewhere.

 

--Nate

  • WNCPBI's avatar
    WNCPBI
    Frequent Visitor
    2 years ago

    Thanks for the reply. I thought that might be the issue too, but setting the locale on the affected columns didn't work either.  I have found that setting the "Enhanced Compute Engine" to Disabled for the dataflow does resolve the issue. Whether this will have any unintended consequences through, I'm not sure, but for now it resolves the issue.