barcelona

more panorama pictures

excel

1 click excel macro tool

Power BI: change the source, refresh the data and move columns

To change the source, in “home”, select “transform data” then “data source settings”.

power bi

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”
power bi
power bi power bi

To re-order the columns, it is not possible to do it in the “calculated” columns, I mean here:

power bi

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”
power bi
power bi power bi

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.

Interesting Management