Forum Discussion
Working with folder files in power query
When I upload a folder into power bi in the power query it creates two folder inside, one "Transform Sample Query" and one "Other Query".
If I gonna clean and do stuff in the dataset where I gonna do it? From Tramsform Sample Query or Other Query?
3 Replies
Typically from the "Other" folder.
All of the queries in the "Transform File From..." in (1) above are used in the Invoke Custom Function (2 above). All further transformations should be one after that in your original query. Note that after invoking the function, there will be several additional steps Power Query does - renaming and removing columns. The last step is usually a "Changed Type" step. You can see in my example, the first thing I did after the big file combine is a Filtered Rows step.
Anonymous wrote:so you mean Transform Query are only for when using invoke function? and other changes gonna be made in Other Query folder?
You do your transformations in the query you initiated the transformation in. In my pic, that is the Downloads query. Don't worry about the folders. Folders are visual and have no bearing on actual query processing. It is just a method for visually organizing.
Unless you know exactly what you are doing, you should NOT touch the auto-generated queries, functions, lists, etc. that the "Combine Files" feature generates.
So back to my image, as I stated above, after the "Changed Type" step, continue with your further transformations.
