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 refreshed the power query, cleared cache and re publish. but it seems that the semantic model in the power bi service still have this old column name.

I've triggered a manual refresh to synchronize the updated schema above error still showing and refresh stopped.


Please let me know how to fix this issue

 

This solun do not work https://community.fabric.microsoft.com/t5/Service/The-column-does-not-exist-in-the-rowset/m-p/4314930

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
     
     

     

10 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 months ago

    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.

    • hrisbud's avatar
      hrisbud
      Regular Visitor
      5 months ago

      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?

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

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

    Hi hrisbud,

    We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

     

     

     

    Thank you for your patience and look forward to hearing from you.
    Best Regards,
    Prashanth Are
    MS Fabric community support

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

    Hi InsightDriven11 

    We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

     

     

     

    Thank you for your patience and look forward to hearing from you.
    Best Regards,
    Prashanth Are
    MS Fabric community support