Power BI Service error updating data

[hasnain0204]

I was working with an excel file, however, i had to add 3 new columns but now the power bi semantic model wont update on the service platform. I get an error about the new column i added. 

Data source errorThe '<oii>Street</oii>' column does not exist in the rowset. Table: Take-up. 

I republished it but the issue persists. help me guys. thanks

[lbendlin]

Is that on Shared, Premium, or Fabric capacity?  (Note that you posted this on the Report Server forum...)

[hasnain0204]

Hey, so the problem was pretty basic, the extra columns which i added where accepted when i refreshed in Power BI desktop (power query) and there were some blank columns which needed to be deleted. I gave them the right data format and refreshed. This fixed the issue on desktop but then on service, I had to delete the existing file and republish the file which i edited on desktop. I do believe that if i published and replaced the file it would have worked. I work with power bi pro version. 

[v-jtian-msft · Accepted solution]

Hi,lbendlin.thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.

Hello,@hasnain0204.I am glad to help you.

You are experiencing an issue in Power BI where three new columns have been added to an Excel file, but you are encountering an error when updating the semantic model in the Power BI Service Platform, indicating that the newly added columns do not exist in the dataset.

You need to ensure that the newly added columns are accepted correctly when refreshing the data in Power BI Desktop (Power Query). Also, remove any blank columns and make sure the data is formatted correctly.

After resolving the issue on Desktop, republish the modified file to the Power BI Service Platform.

If the problem persists, try deleting the existing file and republishing the edited file.
The original Excel data has a few extra columns of data, and there is a change in the architecture (architecture refresh), the problem is that Power BI Service does not support architecture refresh, while Power BI Desktop supports architecture refresh, data refresh and report visuals refresh, while Power BI Service supports data refresh and report visuals refresh. Visuals Refresh
I hope the following refresh documentation will help you.
URL:Data refresh in Power BI - Power BI | Microsoft Learn

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.