Forum Discussion
What is the Transform File from Query doing?
It is not 1 query, but 4 queries that are grouped.
It contains the logic required to combine the files from your folder.
The set of queries is created automatically when chosing "Combine Binaries" in the column header of the column in the navigation table with the files in your folder, along with 4 additional query steps in your "Toggl" query.
You may get rid of it by converting the files to tables, using native functions like Csv.Document or Excel.Workbook, depending on the file types in your folder.
But why would you get rid of it? You can also collapse the group.
The toggl query was not created in my case. Maybe it is an update in the way Power BI Desktop does go about Transform file now. I checked this 09.01.2018 which is quite a long time after the original post.