Forum Discussion

sshweky's avatar
sshweky
Helper III
10 years ago
Solved

Data source hosted on Dropbox

Hi,   I am using Power Query in Excel and need to pull in some data via a query from an Access file on Dropbox. If I add the local version of the file, other users can't use the file b/c they dont ...
  • sshweky's avatar
    sshweky
    10 years ago

    Can you please look at my URL below and see if I did it correctly because it still says "authentication failed". What is the proper format of the filepath?

    ankitpatira wrote:

    sshweky URL should be as below and you choose anonymous method as you already have api token specified in URL

     

     

    https://api-content.dropbox.com/1/files/auto/{FILE PATH}?access_token={YOURAPITOKEN} 

     

     

     

Kamal_PK's avatar
Kamal_PK
New Member
8 years ago

I tried this solution. 

Relocate the Dropbox folder to Drives other than C (OS Drive). For Ex: F:\DropBox (Using Preferences in the Dropbox in Taskbar). Do the same for your peers in their system (Whoever wants to try access the files in Dropbox). 

Now try to work on the files in Dropbox. Peers when they access the files and refresh, data gets updated.

 

Thanks

Kamal

Anonymous's avatar
Anonymous
Not applicable
8 years ago

thanks for your suggestion, but my dropbox folder is already outside C:\...

It is in D:\.

The issue persists.