Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 initi...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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