Forum Discussion

hrisbud's avatar
hrisbud
Regular Visitor
6 months ago
Solved

An error occurred while processing the semantic model - column does not exist in the rowset

ERROR: Data source error - The '<oii>"Site name"</oii>' column does not exist in the rowset. there is one column name changed by our data engineer. i have open the desktop version, fixed and refres...
Need Help
  • v-prasare's avatar
    v-prasare
    5 months ago
    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
     
     

     

v-prasare's avatar
v-prasare
Community Support
6 months ago

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

hrisbud's avatar
hrisbud
Regular Visitor
5 months ago

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?

  • v-prasare's avatar
    v-prasare
    Community Support
    5 months ago
    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
     
     

     

    • v-prasare's avatar
      v-prasare
      Community Support
      5 months ago

      Hi hrisbud,

      As we haven't heard back from you, just checking whether this issue is resolved or if you’re still running into the semantic model column error

       

       

      thanks

      prashanth

    • Shendo94's avatar
      Shendo94
      Frequent Visitor
      2 months ago

      v-prasare I am having the same issue but I am trying to add new coulmns from the SSAS Gold view to the semantic model. It is an external Semantic model, rebuilding to native Fabric is a project but not possible quickly enough to be the solution to adding the column. 

      I am using Tabular Editor 2, and I can add the column and it is visible in the semantic model in Fabric but when I press refresh I get the same error, Rowset does not exist. 

      Do I need tabular editor 3 or something else to force a 'clean up'?