Forum Discussion
An error occurred while processing the semantic model - column does not exist in the rowset
- there is no supported “force clean‑up” switch in Power BI / Fabric Service to automatically remove stale column metadata. Tabular Editor (or fully recreating the semantic model) is effectively the only reliable option
Hi hrisbud
When you republish the semantic model, did it ask to overwrite or replace the existing model? If it did do that, I would recommend if you can connecting via tablet editor to see what the column actually is in the Power BI service and potentially corrected there.
Yes I've selected option to overwrite or replace the existing model while publishing this report. But after publishing report when I refresh it, same error is still there.
Do you mean tabuler editor to see column name?
Hi hrisbud,
Tabular Editor we mean the tool used to inspect the semantic model metadata, either in Power BI Desktop or directly against the published semantic model in the Service.
Even though you selected Overwrite / Replace during publishing, this error usually means the semantic model in the Service is still holding a reference to a column that no longer exists in the source. In some cases, overwriting does not fully clean up stale column metadata.
Thanks,
Prashanth
Yes I know semantic model in the Service is still holding a reference to a column and while publishing it is not overwriting new changes. Is there anyway we can forcefully clean up stale column metadata? or Tabular editor is the remaining ONLY option?