Solved: Dataflow Error

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!

Categories:

Connecting to Data

Dataflows