Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Changes to the original database

Good morning

My database is an ERP that has currently undergone modifications in its fields, several fields have been added to one of the tables.

When I update, I don't see the new fields, what can be the problem?

They tell me that they are not calculated fields, that in the SQL they are but when updating, the initial fields are maintained.

Thank you

  • Finally the problem was that within the data transformation, in Browser of the specific column had to update the preview.

3 Replies

  • Check your Power Query code for Table.SelectColumns transforms.

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator

      Finally the problem was that within the data transformation, in Browser of the specific column had to update the preview.

  • Assuming database is of SQL Server or similar, you'll need to modify the SELECT query to include the additional columns.