Hi all,
I have a staging data flow that pulls data from our Salesforce org and creates a mirrored table in Dataverse. When I publish and try to refresh the table, I get the following error message:
Error Code: Mashup Exception Expression Error, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Expression.Error: We cannot convert a value of type Record to type Text. Details: Reason = Expression.Error;Value = [city = "Annapolis", country = null, geocodeAccuracy = null, latitude = null, longitude = null, postalCode = "21401", state = "MD", street = "100 West Street"];Microsoft.Data.Mashup.Error.Context = System (Request ID: a4df5e49-f969-48c3-887b-7212dc408577).
All of the records should be coming through as Text from Salesforce, so I am unsure of the "We cannot convert a value of type Record to type Text.", and I also attempted to remove all null values, and nothing changed. Thanks in advance for any help!
I was able to fix this by removing the relationship columns that were coming over from Salesforce!
MS.Ragavendar
32
Michael E. Gernaey
19
Super User 2025 Season 1
WarrenBelz
18
Most Valuable Professional