Forum Discussion

dpeacockTHH's avatar
dpeacockTHH
Helper I
4 years ago

Thoughts on organizing Transform files in Power Query?

I pull in a lot of data from external sources that don't have Power BI connectors and save the daily reports in folders.  I use the Folder connector to pull in the data which results in a lot of Tran...
Need Help
v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi dpeacockTHH ,


Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

dpeacockTHH's avatar
dpeacockTHH
Helper I
4 years ago

Unfortunately, none of the responses have addressed the issue.  I pull in data from multiple sources - folders with reports from Apple in one format, folders with reports from Google in another format.  CSVs from ChartMogul and pulling in files from Vertica among other sources.  

 

I would like to be able to move the "Transform file" folders all into one folder to get them out of the way but it won't let me do that.  Alternatively, I'd like to at least have them default to a "collapse" state so they don't take up as much room but haven't found a way to do that either.  Maybe it's just not something that has been addressed yet.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Did you ever get any ideas for this? I have a lot of transform file folders from combining .txt files from a folder and it's really annoying to collapse each one to get them out of the way.