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.
Community SupportHi 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.
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?