Forum Discussion
API provider deleted a column now report can't refresh
We are using a third party API.
They recently removed a column from their source and now all the tables I have that included that column will not update.
Most tables are derived from a single initial table.
How can I remove the missing column from the data source and have that change percolate through all the rest of the tables?
Hi Anonymous ,
Please follow the steps below to check and handle it:
Power Query Editor side:
-
In Power Query Editor, select the initial table and remove the column that no longer exists in the data source. You can do this by right-clicking the column header and selecting “Remove”. Then, apply the changes.
-
Update any steps in the query that reference the removed column: update any calculations, filters, or other transformations that use the column.
Update the measures, visual or other elements which reference that removed column:
-
Check your reports for any visuals, measures, or other elements that reference the removed column, and update or remove these as necessary.
-
Once you’ve made the above updates, try refreshing your data again. If everything has been updated correctly, the refresh should now complete without error.
Best Regards
-
1 Reply
Hi Anonymous ,
Please follow the steps below to check and handle it:
Power Query Editor side:
-
In Power Query Editor, select the initial table and remove the column that no longer exists in the data source. You can do this by right-clicking the column header and selecting “Remove”. Then, apply the changes.
-
Update any steps in the query that reference the removed column: update any calculations, filters, or other transformations that use the column.
Update the measures, visual or other elements which reference that removed column:
-
Check your reports for any visuals, measures, or other elements that reference the removed column, and update or remove these as necessary.
-
Once you’ve made the above updates, try refreshing your data again. If everything has been updated correctly, the refresh should now complete without error.
Best Regards
-