Hi all,
A question of how this should be approached.
The data source (Excel export from database) has changed the names many of the columns meaning that PowerBI no longer automatically picks them up - I can go back into PowerBI refresh data, remove the 'data type' step (after promoting headers) and run this again and that will address most of the issues, but this doesn't automatically update some visuals, and also means that any 'groups' I've created will be lost.
Is this the best way to approach the change in column names (it's a large amount of names sadly), or is there a way to match old names to new ones meaning that they'll automatically apply to existing visuals and groups?
The data is a single export and everytime is the whole list, so it's not a period update that could be used as an append or similar.
Thank you
