Forum Discussion
kheldar
Nov 04, 2021Iron Contributor
Loading every workbook inside a folder using one main file on Sharepoint
Hello, Is it possible to load every workbook inside a folder using one workbook. The workbooks each contain 9 sheets made out of raw data, pivot tables and one sheet that is dedicated to summariz...
- Nov 07, 2021
Otherwise it doesn't work. Your URL to connect is
https://COMPANYNAME.sharepoint.com/sites/odms
Transform returned and in Power Query editor you shall filter this column
to keep only needed folder.
SergeiBaklan
Nov 07, 2021MVP
Otherwise it doesn't work. Your URL to connect is
https://COMPANYNAME.sharepoint.com/sites/odms
Transform returned and in Power Query editor you shall filter this column
to keep only needed folder.
kheldar
Nov 07, 2021Iron Contributor
Thank you!!!! It worked.
- SergeiBaklanNov 08, 2021MVP
kheldar , glad to help