Forum Discussion
Solved
Manually updating Tables?
Hi, I have created a tool to be used by people who are not excel pros. The tool accepts data from 2 or more csv-style reports (output from other programs) and uses it to calculate a data pres...
ColinJHarrison Hi Colin. 'The article in the link below, demonstrates how you can connect PQ to files on Sharepoint or an entire Sharepoint folder.
https://www.myonlinetraininghub.com/get-data-from-onedrive-or-sharepoint-with-power-query
Hi again Riny. OK, so I tried setting up a query, and here's the problem I keep hitting with this client. I use their Sharepoint system. I sync files locally, but I am actually working on their system. Nevertheless, when I set up a power query, it only works locally. When someone else accesses the file (which is saved on Sharepoint) and tries to call the refresh function, they get a [Datasource.error] which clearly is looking for a local path ("C:\Users..."). How do I stop that from happening? 🙂
ColinJHarrison Hi Colin. 'The article in the link below, demonstrates how you can connect PQ to files on Sharepoint or an entire Sharepoint folder.
https://www.myonlinetraininghub.com/get-data-from-onedrive-or-sharepoint-with-power-query