Forum Discussion
Connecting to data source hosted on Dropbox
Hi JohnSwid,
Which file or data source do you store in Dropbox? I am trying to connect to a Excel file stored in DropBox following ankitpatira’s suggestions and everything works well.
Moreover, some ideas about that connecting to data source stored in Dropbox have been submitted in the following links, please vote them. Some changes may be made for the connection to Dropbox and it could be easier for us to connect to Dropbox from Desktop in the future.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6663925-dropbox
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9045649-please-add-more-data-services
In addition, you can also consider to store files in OneDrive instead of Dropbox and connect to them from Power BI Desktop.
Thanks,
Lydia Zhang
- mike_honey9 years agoMemorable Member
While researching this topic, I noticed that all the examples given appear to be for the Dropbox v1 API, which has been deprecated and will be turned off in a few months (June 2017):
https://blogs.dropbox.com/developers/2016/06/api-v1-deprecated/
The v2 API looks much more complex - there doesnt appear to be any direct equivalent for the method suggested above (single HTTPS call with an API Key). The authentication requirements now seem more complex:
https://www.dropbox.com/developers/reference/auth-types#user
It's stumped me for now - has anyone got this working?
- elliotdixon9 years agoResponsive Resident
I agree with mike_honey - cant seem to get it working.
Any tips on connecting into the dropbox files would be great.
- hugoberry9 years agoResponsive Resident
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 outThe 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.