Forum Discussion
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.
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.
Thanks for the thoughtful response. I have tried so much to troubleshoot it. Ultimately I have rewritten the connector to return a table and have more error handling. This did solve it. It is somewhat of an anomaly as the connector and PowerBi had previosuly worked. Maybe its an error that saved me from publishing the report to the business and then having greater issues down the track.