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 have the same local file path to Dropbox as I do.

 

Is there some way to connest to the web version of the file on Dropbox? I tried, but it doesn't see the tables inside the database?

 

Any other ideas?

 

Thanks,

 Steven

  • 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} 

     

     

     

13 Replies

  • ankitpatira's avatar
    ankitpatira
    Community Champion
    10 years ago

    sshweky Make use of Dropbox REST APIs. 

     

    1. Go to https://www.dropbox.com/developers and sign in and get API token.

     

    2. In power bi desktop click web connector enter URL as below, replaceing {FILE PATH} and {YOURAPITOKEN}.

     

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

    3. Right click result of query and select Access. 

     

     

     

     

  • 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.
  • DUYARRA_BI's avatar
    DUYARRA_BI
    Regular Visitor
    3 years ago

    Hello,

     

    I tried again and it works fine, here is the M code of the query, in this case, retrieving a CSV file:

     

     

    let
    Origen = Csv.Document(Web.Contents("https://www.dropbox.com/s/------/Anexar1_peque.csv?dl=1"),[Delimiter=","]),
    #"Tipo cambiado" = Table.TransformColumnTypes(Origen,{{"Column1", type text}})
in
    #"Tipo cambiado"

     

    Note that I changed the ?dl=0 for ?dl=1