cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aaande8 Frequent Visitor
Frequent Visitor

Broken Power Query

Currently I pull data form a sharpoint 2016 list. I had all my pivot tables and charts set up. I had deleted and re added a column in the sharepoint list which seems to have broke my power query. Error message indicated below. Within sharepoint I had added a new column called "Reason SLA Missed" to see if it would pull in the data to data model, which it did, then I deleted the old column named "Reason for SLA Miss" and renamed the new column to match the old. I went back into the power query to update and I get the error below. I changed the column name back to "Reason SLA Missed" and just update the name within the power query. However am still getting the same issue. Please see screen shots. Am wondering if there is something am not updating to get the power query to pull the new column in and forget the old column. Capture4.PNGCapture3.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
aaande8 Frequent Visitor
Frequent Visitor

Re: Broken Power Query

https://stackoverflow.com/questions/29135515/excel-powerpivot-update-error-object-was-not-found-in-t...

I found my solution here. It had to do with the filter that was on the pivot chart that was using the old column that I deleted. I removed the filter and it seems to have worked. Solution below.

 

The cleanest solution I found up to now is to use your previous working model (the one which worked fine before the update) and find all the pivots where you were filtered on "Desktop". Set these filters to "All" and then run your update.

This way you don't lose your pivot table, which sometimes is a big rework to rebuild, specially when you had charts and other dependencies linked to such pivot.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Broken Power Query

Hi @aaande8 

You delete a column or change the column name which is imported into Power BI data model,

when refreshing, it can't find the column by the column name imported before from data source,

thus, it throws an error.

 

You could add a new column in data source, then refresh from Power BI/Power Query,

delete the old column from Power BI/Query, or rename the new column in Power BI/Query.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

aaande8 Frequent Visitor
Frequent Visitor

Re: Broken Power Query

When I changed the new columns name to Reason for SLA Missed and refreshed the data in the power query it still shows the old name "Reason SLA Missed" I am not sure why that wont pull in the new name now. Any idea as to why that is?

aaande8 Frequent Visitor
Frequent Visitor

Re: Broken Power Query

https://stackoverflow.com/questions/29135515/excel-powerpivot-update-error-object-was-not-found-in-t...

I found my solution here. It had to do with the filter that was on the pivot chart that was using the old column that I deleted. I removed the filter and it seems to have worked. Solution below.

 

The cleanest solution I found up to now is to use your previous working model (the one which worked fine before the update) and find all the pivots where you were filtered on "Desktop". Set these filters to "All" and then run your update.

This way you don't lose your pivot table, which sometimes is a big rework to rebuild, specially when you had charts and other dependencies linked to such pivot.

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors