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} 

     

     

     

sshweky's avatar
sshweky
Helper III
10 years ago

ankitpatira

 

Hi Ankit,

 

 

Thank you so much! However, I ran into 1 small roadblock. When I hit connect I get this box where I need to sign in.

 

Here is s screenshot of what I am seeing...

https://www.dropbox.com/s/3ssfx6c2hq5p5kr/Capture.PNG?dl=0

 

I tried to log in a bunch of different ways and it tells me 'user not authourized'. Any ideas?

 

Here is the final link tot he file with API Token & Path.

https://api-content.dropbox.com/1/files/auto/https://www.dropbox.com/s/vyt5wxklr9sh5ns/fc.mdb?dl=0?access_token=lNRU4j3IhxEAAAAAAAY_xJ1RC1SiSylWAhLbJRXlDhfv2Qds7ye4Qomt6Zt1NGE5

 

Thank you so much for your help!!!

 

 

Steven

 

 

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

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} 

 

  • sshweky's avatar
    sshweky
    Helper III
    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} 

     

     

     

      • eaglewoods's avatar
        eaglewoods
        Frequent Visitor
        3 years ago

        Have you or anyone else had an issue when the dropbox explorer link got changed automatically?

        I have an excel file which I have linked using your method in various PBI reports, like this "https://www.dropbox.com/s/je1pd9qmopp5t_____________rec2015.xlsx?dl=01".

        And now I am back from my holiday and all the PBI reports are not refreshing because the link has changed. The 'file' is still in the same dropbox folder and has the same file name. I asked my colleagues, but nobody changed the file location or such.

        Just wondering if there is some better way to link the dropbox file in the future inorder to avoid opening all the desktop files> editing the link> and publishing it again. Chaotic!