Modify R code before refresh for whole dashboard

[Anonymous]

Good morning guys,

I am fairly new with Power BI so I apologise if the question is too simple 🙂

I connected PowerBI and RStudio to query from Postgres and modify the dataset, in order to upload smaller datasets, which I use for visualisations.

I have now 4 different datasets, all with the same Source Query ( i.e. R code). I have noticed that it would be better for me to add one column in my last 2 datasets, and I can do it with a line of code in R. I am now wondering, is there a way to refresh all 4 datasets at once, AFTER modifying the underlying code? 

When starting the project I did "Get Data" only once and then selected the 4 dataframes I needed, but after loading the DATA the firt time it seems that I can only modify them one by one!?

So far I managed to modify them through the query editor, but I need to do it  one dataset at the time.

Thanks

[lbendlin]

Power Query queries can reference each other.  Create one query with all the columns, then reference if needed.  Or use your "master"  query throughout.