Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Appending sample file

Hi! The files that I have to work with have 2 column rows. Therefore, in "Transform Sample File" I transpose the 2 column rows to make each file have 1 column row. Before I do that though, I duplica...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Anonymous ,

     

    I'm not sure why you're duplicating your Transform Sample File query. The whole point of the folder combine process is that Power BI performs exactly the same transformations on every file in the folder (based on your Transform Sample File steps) then appends them for you.

    If you don't want to do exactly the same transformations on each file, then you should just be importing them as individual sources/queries into Power Query and transforming them separately.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi Anonymous ,

 

I'm not sure why you're duplicating your Transform Sample File query. The whole point of the folder combine process is that Power BI performs exactly the same transformations on every file in the folder (based on your Transform Sample File steps) then appends them for you.

If you don't want to do exactly the same transformations on each file, then you should just be importing them as individual sources/queries into Power Query and transforming them separately.

 

Pete