Forum Discussion
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
ColinJHarrison Well, Power Query is the tool for you. Set it up correctly once and teach your users to press one button, every time the CSV data changes. No manual process, whatsoever.
- Hi Riny! Yeahhh, I know... In principle... And in the long run that will probably be the solution I work towards, but my desire to provide a slightly more "hands on" solution in the short term is partially a change management thing, partially an issue with network accessibility (for me).
- 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
