To change the source, in “home”, select “transform data” then “data source settings”.
To refresh the data, there are 2 options:
- Option 1, to refresh all data, use the “refresh” button
- Option 2, to refresh a specific data, in “fields”, click on the “3 dots” then select “refresh data”
To re-order the columns, it is not possible to do it in the “calculated” columns, I mean here:
It can be done only by using the “transform data” option, there are 2 choices:
- 1. Transform data -> transform data
- 2. In “fields”, select the table, click on the “3 dots” then select “edit query”
Here I can move the columns as I want but once done, it will not reflect it in the “calculated” column view.
There is no impact on the result, it is more about “esthetic” than anything else but if it is something that annoy you, the only way to do it, it is to start from 0, redoing everything.