Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am getting errors on Record type objects when I try to apply a schema in my custom connector even though I have added the nullable type identifier.
The below example shows whenever I have location = null, it throws an error.
Here is a condensed listing of how I am defining my schema in my PQ file:
ProjectType = type table [ ... location = nullable LocationType, ...], LocationType = type [ country = text, state = text, streetName = text, streetNumber = text, suite = text, city = text, zip = text, complete = text, coords = nullable CoordsType ]
I have defined location as being a nullable record.
I copied the Table.ChangeType helper function from here: https://learn.microsoft.com/en-us/power-query/helper-functions#tablechangetype.
If I change the schema definition to nullable any then it works but then I do not have my schema applied for the location records that are provided.
ProjectType = type table [ ... location = nullable any, ...],