Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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....
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      aaronrose
      Regular Visitor
      3 years ago

      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.