Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
great reply from @venal . What I have found in my experience is the combine binaries ( and the associated custom function / helper queries ) can slow the upload down quite a bit. And it makes it quite messy if you have many of these loads to do with a big ETL.
So I went looking for a better method a while back and I found one from Ruth at Curbal.
Curbal Mutiple Files from Folder
let
Source = SharePoint.Files("https://XXXXXXX", [ApiVersion = 15]),
#"Added Custom" = Table.AddColumn(Source, "Custom", each Excel.Workbook ([Content])),
in
#"Added Custom"
The gist is to adjust the M code to something like this: ( Where XXXX is your sharepoint location)
This allows for a faster and cleaner load of the files ( when there are a whole bunch)
Hope this helps with the solution down the track.
Manfred
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |