Forum Discussion

Carlos Cardenas Velasquez's avatar
Carlos Cardenas Velasquez
Copper Contributor
Jul 03, 2018
Solved

Get & Transform Data | Get Data from a folder transforming the files before the combination

Hello,   I want to read the files in a folder, but those files needs some transformation before I can combine them with power query. Normally what i would do if all of them were in a table format i...
BI & Data Analytics
Requests
  • Wyn Hopkins's avatar
    Wyn Hopkins
    Jul 04, 2018

    Hi Carlos Cardenas Velasquez

     

    Start with Combine and Edit

     

     

    Then do your transformations (removing rows and unpivotting) in the Transform Sample File step

     

     

     

    Those transformations will then be applied to all the files as they are pulled in.

     

     

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Jul 04, 2018

Hi Carlos Cardenas Velasquez

 

Start with Combine and Edit

 

 

Then do your transformations (removing rows and unpivotting) in the Transform Sample File step

 

 

 

Those transformations will then be applied to all the files as they are pulled in.

 

 

  • chucknjoy's avatar
    chucknjoy
    Copper Contributor
    Oct 22, 2020

    Wyn Hopkins I have done this multiple times, however, the buttons at the bottom, combine and load, are no longer available.

     

    I am using Excel 2016

    • Wyn Hopkins's avatar
      Wyn Hopkins
      MVP
      Oct 23, 2020

      hi chucknjoy 

       

      Id suggest starting a new post and adding a screenshot to help us debug

       

      Cheers

       

      Wyn

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Jul 04, 2018
    Also, load as Connection Only to start with.

    then After it's complete go to the Query Pane and change your load destination to Table or Data Model

Resources