Apply transformations to multiple data sources/tables

[Anonymous]

Hi all

I'm brand new to PowerBI but I'm learning! As a learning exercise, I have multiple tables containing the same data but from different sources... As in... It all comes from one website but... it's different... Ugh...

Ok so one source is this:

http://pvoutput.org/intraday.jsp?id=53242&sid=48433

And the other is this:

http://pvoutput.org/intraday.jsp?id=53967&sid=49100

So you can see, they're very similar. My intention is to then play around with comparing the 2.

Once imported into PowerBI I need to perform a number of transformations to clean the data up. Is there a cool way of applying the same transforms to multiple sources/tables?

Thanks everyone!

[v-sihou-msft · Accepted solution]

@Anonymous

In this scenario, I suggest you transform your data within in Query Editor. It supposes to add steps in your Power Query.

Since your two dataset are similar, you can just copy same Power Query and just replace the source.

Regards,

Simon Hou

[Anonymous]

You guys know if is there a way to do it automaticaly, in my case I have dozens os similar datasets that I need to apply the same transformations.

Tks

[aaronrose]

Same here. I'm working in Fabirc Data Lake but the functionality request is essentially identical. How to we apply the same transformation steps across dozens of very similar tables.