cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mark_carlisle
Advocate III
Advocate III

Cannot resolve collation conflict between Latin1_General_100_CI_AS_KS_WS_SC and ...

Since the enhanced compute engine has been made GA I've decided to turn it on. I've Disabled the engine on all dataflows as I want to test it on one before rolling out in stages across the others.

 

I'm encountering the following error though on my first dataflow.

 

Error: Data Source Error : DataSource.Error: Microsoft SQL: Cannot resolve collation conflict between "Latin1_General_100_CI_AS_KS_WS_SC" and "Latin1_General_100_BIN2_UTF8" in add operator occurring in SELECT statement column 1. DataSourceKind = SQL DataSourcePath = .\cdsasqlcache;db$059b81e3-795a-4c82-976f-1b5a4f186051 Message = Cannot resolve collation conflict between "Latin1_General_100_CI_AS_KS_WS_SC" and "Latin1_General_100_BIN2_UTF8" in add operator occurring in SELECT statement column 1. ErrorCode = -2146232060 Number = 451 Class = 16.. RootActivityId = 2ddb10ed-1d56-4182-a59f-a624d45bced8.Param1 = DataSource.Error: Microsoft SQL: Cannot resolve collation conflict between "Latin1_General_100_CI_AS_KS_WS_SC" and "Latin1_General_100_BIN2_UTF8" in add operator occurring in SELECT statement column 1. DataSourceKind = SQL DataSourcePath = .\cdsasqlcache;db$059b81e3-795a-4c82-976f-1b5a4f186051 Message = Cannot resolve collation conflict between "Latin1_General_100_CI_AS_KS_WS_SC" and "Latin1_General_100_BIN2_UTF8" in add operator occurring in SELECT statement column 1. ErrorCode = -2146232060 Number = 451 Class = 16 Request ID: 9ad5a3cc-97d5-2f49-0a03-db7280d69ef4.

 

The lineage of this is below...

 

Screenshot 2020-11-13 135949.png

 

And the Refresh History CSV

 

Run timeDataflow nameDataflow refresh statusEntity nameStart timeEnd timeEntity refresh statusError
Invalid dateINGEST_CLOUD_SurveysFailedRRFrontline__Feedback__c13/11/2020 13:13:3313/11/2020 13:14:46Completed 
Invalid dateINGEST_CLOUD_SurveysFailedRRFrontline__Insight__c13/11/2020 13:13:3313/11/2020 13:14:11Completed 
Invalid dateINGEST_CLOUD_SurveysFailedClosed_Loop__c13/11/2020 13:13:3313/11/2020 13:13:44Completed 
Invalid dateINGEST_CLOUD_SurveysFailedUser13/11/2020 13:13:3413/11/2020 13:13:38Completed 
Invalid dateCLEANSE_SurveysFailedDIMENSION - Closed Loop13/11/2020 13:13:3313/11/2020 13:13:34Skipped 
Invalid dateCLEANSE_SurveysFailedFACT - Rant & Rave Feedback13/11/2020 13:14:4613/11/2020 13:14:49FailedError: The current operation was canceled because one or more operations failed... RootActivityId = 2ddb10ed-1d56-4182-a59f-a624d45bced8 Request ID: 9ad5a3cc-97d5-2f49-0a03-db7280d69ef4.
Invalid dateCLEANSE_SurveysFailedDIMENSION - Rant & Rave Feedback13/11/2020 13:14:4613/11/2020 13:14:48FailedError: Data Source Error : DataSource.Error: Microsoft SQL: Cannot resolve collation conflict between "Latin1_General_100_CI_AS_KS_WS_SC" and "Latin1_General_100_BIN2_UTF8" in add operator occurring in SELECT statement column 1. DataSourceKind = SQL DataSourcePath = .\cdsasqlcache;db$059b81e3-795a-4c82-976f-1b5a4f186051 Message = Cannot resolve collation conflict between "Latin1_General_100_CI_AS_KS_WS_SC" and "Latin1_General_100_BIN2_UTF8" in add operator occurring in SELECT statement column 1. ErrorCode = -2146232060 Number = 451 Class = 16.. RootActivityId = 2ddb10ed-1d56-4182-a59f-a624d45bced8.Param1 = DataSource.Error: Microsoft SQL: Cannot resolve collation conflict between "Latin1_General_100_CI_AS_KS_WS_SC" and "Latin1_General_100_BIN2_UTF8" in add operator occurring in SELECT statement column 1. DataSourceKind = SQL DataSourcePath = .\cdsasqlcache;db$059b81e3-795a-4c82-976f-1b5a4f186051 Message = Cannot resolve collation conflict between "Latin1_General_100_CI_AS_KS_WS_SC" and "Latin1_General_100_BIN2_UTF8" in add operator occurring in SELECT statement column 1. ErrorCode = -2146232060 Number = 451 Class = 16 Request ID: 9ad5a3cc-97d5-2f49-0a03-db7280d69ef4.
Invalid dateCLEANSE_SurveysFailedFACT - Closed Loop13/11/2020 13:14:4613/11/2020 13:14:49FailedError: The current operation was canceled because one or more operations failed... RootActivityId = 2ddb10ed-1d56-4182-a59f-a624d45bced8 Request ID: 9ad5a3cc-97d5-2f49-0a03-db7280d69ef4.
Invalid dateCLEANSE_SurveysFailedLINKED_RRFrontline__Feedback__c13/11/2020 13:14:4613/11/2020 13:14:46Completed 
Invalid dateSurveysFailedDIMENSION - Closed Loop13/11/2020 13:13:3413/11/2020 13:13:34Skipped 
Invalid dateSurveysFailedFACT - Rant & Rave Feedback13/11/2020 13:14:4913/11/2020 13:14:49FailedError: One or more upstream operations failed... RootActivityId = 2ddb10ed-1d56-4182-a59f-a624d45bced8 Request ID: 9ad5a3cc-97d5-2f49-0a03-db7280d69ef4.
Invalid dateSurveysFailedDIMENSION - Rant & Rave Feedback13/11/2020 13:14:4813/11/2020 13:14:48FailedError: One or more upstream operations failed... RootActivityId = 2ddb10ed-1d56-4182-a59f-a624d45bced8 Request ID: 9ad5a3cc-97d5-2f49-0a03-db7280d69ef4.
Invalid dateSurveysFailedFACT - Closed Loop13/11/2020 13:14:4913/11/2020 13:14:49FailedError: One or more upstream operations failed... RootActivityId = 2ddb10ed-1d56-4182-a59f-a624d45bced8 Request ID: 9ad5a3cc-97d5-2f49-0a03-db7280d69ef4.

 

How can I resolve this as I don't have access to the underlying SQL tables that the Enhanced Compute Engine creates.

2 REPLIES 2
lbendlin
Super User III
Super User III

Do you have a single data source or are you combining data sources?  Can you show your Power Query code? (sanitized)

I'm merging two tables but the source is the same, i.e. another PBI dataflow. I've since isolated the issue to an unpivot of columns and I've just implemented another solution rather than doing the unpivot. Which has worked around the issue.

 

I may revisit the unpivot solution at a later date to see if I can resolve it but as it stands it not worth investing more time at the moment since its working and the query takes around the same time to process.

 

Thanks for responding though.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors