API provider deleted a column now report can't refresh

[Anonymous]

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?

[Anonymous · Accepted solution]

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