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...
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
Helper IIISubstitute CSV.Document instead of Excel.workbook in the video. Works just as well.