Powerquery - Dynamic path setup
I have setup a file with multiple queries. The users are expected to download the file from the server, save it onto their their own private folders, update the path field that has been setup as a table inside the excel workbook, and refresh the query and it should work.
The solution works fine on my machine. When i move the folder location to other folders, it also works fine. However when my staff do it, it does not seem to work. I am running a 64bit version of excel and staff are running a 32bit version. This is the only difference between our machines.
The source for the queries are worded as suchh : = Pdf.Tables(File.Contents(Table1&"\PO.pdf"), [Implementation="1.3"])
The table1 is a drill down of the path which is entered by user into the excel table.
Below is the error message. Any suggestions on how to fix this will be greatly appreciated
I found the solution. It is simply to set the privacy level to None for both global and current workbook 