SEANWHYLAND
New Member
- Joined
- Sep 7, 2015
- Messages
- 8
Good evening all.
I am trying to aggregate data from other workbooks that are contained within file folders on sharepoint. The method that I used previously use to work. PowerQuery would navigate to the sharepoint folder and then would start to aggregate all of the tables from the excel files contained within the sharepoint folder. Now, I get an error, "[DataSource.Error] An IO error occurred while trying to access the file '\\sharepoint\support\facop\'."
Tried to use a html address but I am not able to do drill down to where the excel files are located and the tables contained within.
Any thoughts?
Thanks in advance
I am trying to aggregate data from other workbooks that are contained within file folders on sharepoint. The method that I used previously use to work. PowerQuery would navigate to the sharepoint folder and then would start to aggregate all of the tables from the excel files contained within the sharepoint folder. Now, I get an error, "[DataSource.Error] An IO error occurred while trying to access the file '\\sharepoint\support\facop\'."
Tried to use a html address but I am not able to do drill down to where the excel files are located and the tables contained within.
Any thoughts?
Thanks in advance