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} 

     

     

     

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