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

[hrisbud]

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

[v-prasare]

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

[v-prasare]

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

[GilbertQ]

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]

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]

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