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.

 

 

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