Forum Discussion

JohnSwid's avatar
JohnSwid
New Member
9 years ago

Connecting to data source hosted on Dropbox

Hello PowerBI-Ites,   Has anyone had any luck connecting to Dropbox as a data source.  Couldn't find many articles on this topic.  Here's one  article that had a solution we couldn't get to work: h...
hugoberry's avatar
hugoberry
Responsive Resident
9 years ago

The documentation on their developer site is quite comperhansive https://www.dropbox.com/developers/documentation/http/documentation

As for some boilerplate code to get you going have a look at the snippet below for an example of geting folder listing.

let
    data = [    path= "/code",
                recursive=false,
                include_media_info=false,
                include_deleted=false,
                include_has_explicit_shared_members=false],
    header = [  #"Authorization"="Bearer ZZZZZZZZZZZ",
                #"Content-Type"= "application/json"],
    response = Web.Contents("https://api.dropboxapi.com/2/files/list_folder",[Content=Json.FromValue(data),Headers=header]),
    out = Json.Document(response,1252)
in
    out

The only setup that I had to do on the Dropbox site was to create an App in the developer space and then generate an access key, which by the way is ZZZZZZZZZZ in my snippet.

    • masplin's avatar
      masplin
      Impactful Individual
      9 years ago

      Actually I managed to set up the new personal gateway so that i coud use the files on dropbox as a data source for a PBIX file

       

      I think thisis doing somethnig different? Coudl you just explain in what instances I woudl be looking to use this for futre refernece?

       

      Thnaks

      Mike 

      • ImkeF's avatar
        ImkeF
        Community Champion
        9 years ago

        Hi guys,

        thanks for these helpful different solutions! I've picked up some code bits from this thread and created a function that makes it pretty easy to grab files from a dropbox-folder: https://www.youtube.com/watch?v=eEVRO-Zc7pg

         

        This should be helpful for folks who are not so tech-savy and might stumble across this post.