Forum Discussion
Dataset Refresh Error : The data types varchar and uniqueidentifier are incompatible
I'm seeing exactly the same - stopped working on the 13th September.
I've got it working by calling the Text.From function (https://msdn.microsoft.com/en-us/library/mt186370.aspx)
= Table.AddColumn(#"Filtered Rows", "Content Key", each [VenueId] & "#" & [ContentId])
to
= Table.AddColumn(#"Filtered Rows", "Content Key", each Text.From([VenueId]) & "#" & [ContentId])
I notice the error talks about the "add operator". I also notice you are talking about concatination. What does your concatination statement look like? Is it using the + operator? Could you convert it to the & operator?
Thanks for the responce Anonymous.
I am adding a custom column where I concatinate the uniqueidentifier field to a string. The step before creating the new field I made sure the uniqueidentifier field was of type "Text" and when doing the concatination I used the "&" operator.
This is something that has being working for ages, but is broken in the Septemeber 2017 release.
Any thoughts on a work around?
Microsoft ... Can you confirm this is a bug or is it working as intended?
I'm seeing exactly the same - stopped working on the 13th September.
I've got it working by calling the Text.From function (https://msdn.microsoft.com/en-us/library/mt186370.aspx)
= Table.AddColumn(#"Filtered Rows", "Content Key", each [VenueId] & "#" & [ContentId])
to
= Table.AddColumn(#"Filtered Rows", "Content Key", each Text.From([VenueId]) & "#" & [ContentId])
I spoke to Microsoft support and they confirmed this issue is due to a design change to improve direct query performance against SQL Server. No ETA for a fix as of yet.
Text.From is a good work around.