Repeat changes across different CSV files

[ShaneElford]

Hi BI community,

I create monthly reports for my company using CSV data.  There are several reports I have to make all pertaining data from the same website.  I load a CSV and make a bunch of changes in Power BI and export my results.  Since there are several reports all coming from the same website holding similar data I end up making the same changes to this data 7 or 8 times.  My question is, is it possible to make changes to one set of data and open up a new form of data and automatically have that data transformed the way the original one was transformed?

For example:

I have 2 CSVs, Client1.csv and Client2.csv.  I import Client1.csv into Power BI and change the data as needed.  Client2.csv contains all similar data, can I import Client2.csv and automatically change all the fields?

[ShaneElford · Accepted solution]

I think the best way I have found is to edit the 'source' in the 'edit query' settings.  This seems to do all the adjustments afterwards and speeds up the process 10 fold 🙂

[v-piga-msft]

Hi @ShaneElford ,

It seems that you have solved your problem.

Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry