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.

  • Kamal_PK's avatar
    Kamal_PK
    New Member
    8 years ago
    Make sure the file source path is similar to whoever access the files, like d:\Dropbox. I tried with my team it's working.
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      no... I don´t want it working on PBI Desktop. I need it working on PBI Service, PBI Service cannot connect directly to Dropbox cloud. that is my problem: cannot make it work from PBI cloud to dropbox cloud.