Forum Discussion
dpeacockTHH
Helper I
Helper IThoughts 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...
Ashish_Mathur
Super User
Super UserHi,
Follow the steps in this video to avoid creating so many sub queries - Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks.
dpeacockTHHHelper I
Helper IUnfortunately, these aren't from importing Excel spreadsheets but folders with multiple csv files. The Excel spreadsheets that I bring in come in fine.
- Linnil
Helper III
Substitute CSV.Document instead of Excel.workbook in the video. Works just as well.