Strange Error - After transforming data - Cannot find Column

hi HankScorpio2 ,

Hey, just checking, when you expand divisionIds in the Power Query editor and immediately hit Refresh Preview (before applying), does it still show the values without errors? Sometimes with custom connectors, the preview is cached, but the actual refresh call can return slightly different schema (e.g., column renamed, case change, or missing entirely in certain calls). If the backend doesn’t always return divisionIds, Power BI will drop that column on load and throw this error. You might need to add a step to handle missing columns (like Table.AddColumn with a default value) before expanding.

Regards,
Akhil.