Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to 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
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
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
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.