Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |