Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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...
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 11 | |
| 7 | |
| 4 | |
| 3 | |
| 3 |