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

 

[RoryA]

Do you have OneDrive for Business?

 

[thewiseguy]

i don’t believe it’s for business. just a personal account. will that make a difference?

 

[RoryA]

I'm not sure if you can do it from a personal OneDrive. I'll try and test later on (can't use personal account at work).

 

[thewiseguy]

if i simply move the 2 files from zoho workdrive to Onedrive, i am assuming the link won’t work correct? i’m new to power query….is it easy to change the file path so that the link will work in its new destination?

 

[RoryA]

It's pretty simple to edit the path in the Source step of a query. The tricky bit with OneDrive is figuring out the correct path.

 

[thewiseguy]

so i do have OneDrive for business. just confirmed.

 

[RoryA]

OK, then see the section titled "From the web connector using a file URL' in this MS article for a way to get the file path you need.

 

[thewiseguy]

will this work when i am on-premise and have everything linked and saved locally as well?

 

[RoryA]

As long as you have internet access because it will link to the online file, not your locally synced copy.