Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
hasnain0204
Frequent Visitor

Power BI Service error updating data

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

 

1 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

vjtianmsft_0-1729828620111.png


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.
  

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

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

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. 

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

vjtianmsft_0-1729828620111.png


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.
  

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.