Apr 30 2021 07:19 AM
Good afternoon to all !
I have an Excel file with 2 sheets.
One sheet called "Portefeuille" is a PowerQuery table getting the info from an excel sheet on Sharepoint.
One sheet called "Team A" with a table that should take the info from the Power Query table in the sheet "Portefeuille" and use it to update itself.
This is no easy task. Do you have something in mind?
Please see the Excel inclosed.
Thank you very much for your help,
Regards,
Lotam
May 08 2021 08:03 PM
You can only update the source file that the power query is pointing to get the data from.
If you're going to allow your users to access the source file to update it, then there needs to be an auditor/reviewer before the update can be done. Ideally the query should be from a folder thereby the power query will just combine the updates dropped into that folder without modifying the existing sources that way if there were errors in the recent update all you have to do is pull that particular errant csv file so it can be corrected and dropped back into the folder when the error has been resolved, so your users can copy the lines from the query, put it on their excel update then save it as a csv file and drop their update into the folder. you must also institute a file naming convention to identify who created the update and when the file was created.
May 10 2021 08:15 AM