Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
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 in the schema.
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. I also have been following the TripPin examples to build out my connector.
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,
...],
The REST API I am connecting to sometimes has the location records filled in but sometimes location is just null as in the below examples:
I can't figure out where in the Table.ChangeType helper function I can make a tweak to cover the null record conditions but I would have thought making it nullable would have done the trick. Any thoughts?
This appears to be similar to this previous unanswered post from a few years ago: https://community.fabric.microsoft.com/t5/Power-Query/Error-with-nullable-record-type-when-using-Tab...
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save โฌ200 with code FABCMTY200.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |