Power Query from the Cloud??

[thewiseguy]

I currently use power query as a means to generate company proposals. I have a "catalog" worksheet that contains all of our products and services and then I have a "proposal generator" which contains each projects data input. The proposal generator pulls data from the catalog and spits out the information for our clients. This works great when I am in the office, as these documents are on a local folder (linked up to the cloud).

FYI - I am using zoho workdrive as our cloud provider.

I tried to use these files at home but then realized the locations are not being found when the data was refreshed.

Can I rectify this by using OneDrive? Will OneDrive allow me to use these linked files whether I am in the office or at home?

Many thanks in advance!


/m

 

[thewiseguy]

so will i need to go through the procsss outlined in your example, each time I am linking data? I have about 50 tables to link.

 

[RoryA]

50 separate workbooks, or 50 tables in one workbook? The process above is just to get the path you need. It should be fairly straightforward to figure out adjustments to use other workbooks.