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
What is the data source, and have you tried refreshing it on the Power Query side before clicking close and apply button to check if it shows any errors?
Its a custom connector I wrote. I set up the transform yesterday in Powerbi and it was all working. I created some measures. I returned to it today and received this error. So I created a new blank report and connected to the data source again. It retrieves the data and shows that there are dividionids. Its just when it goes to refresh it can't find the column it just pulled.
does it show an error in the last step of the query?
Hi. No the divisionids are the first step. When i redid it expanding the list to new rows was the only action I took.
