cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Updating Dataset with Removed Columns

Hi everyone!

I have been working with Power BI for just about a month now but am having some difficulties with updating my data. When I originally uploaded my table, it had 9 columns:

 

Capture.PNG.
Since Grey and Orange were never the correct colours to be used, I deleted them from the file. So now, the document appears as:

 Capture2.PNG.

 

But now when I'm trying to refresh the data, even though the columns Orange and Purple were empty, I'm getting an error that says
"Expression.Error: The column 'Orange' of the table wasn't found."

Is there any way I can still update the data even though the original data had the extra columns? It would be a pain to have to manually add the columns Orange and Grey every time I wanted to refresh my data. 

Thanks!

 

UPDATE: The reason it said Expression.Error is because it was still trying to change the type of Orange and Grey, so I just modified the "Chahnged Type" Step. The new Error is:

"Failed to save modifications to the server. Error returned: 'Column 'Year for Seller' in the table 'Colour Sellers' cannot be found or may not be used in this expression. An unexpected error occured (file 'tmtransactioin.cpp', line #, function 'TMTransaction::GetProxyFromPrevSavePoint').' However, I don't have any measures or calculated columns that are related to this column in the other table at all, and the 'Colour Sellers' table is no longer there.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: Updating Dataset with Removed Columns

I'm sorry it turns out I had not deleted the table after all, just hidden it. I deleted the 'Colour Sellers' table and everything works now 🙂 
Thanks for your help!!

View solution in original post

4 REPLIES 4
Resolver II
Resolver II

Re: Updating Dataset with Removed Columns

go into edit queries and remove the step where you deleted the column

query.png

 

Highlighted
Super User IV
Super User IV

Re: Updating Dataset with Removed Columns

If you could go into Query Editor, Advanced Editor and paste the text of your query, we can probably point out where you are getting the error.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Resolver I
Resolver I

Re: Updating Dataset with Removed Columns

I actually had to remove the entire table because it turned out to be irrelevant data, and the column was a calculated column within the table I had deleted.

Highlighted
Resolver I
Resolver I

Re: Updating Dataset with Removed Columns

I'm sorry it turns out I had not deleted the table after all, just hidden it. I deleted the 'Colour Sellers' table and everything works now 🙂 
Thanks for your help!!

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors