Forum Discussion
Broken Power Query
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.
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.