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