Forum Discussion
Apply transformations to multiple data sources/tables
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!
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
3 Replies
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
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.
