Reply
Regular Visitor
Posts: 41
Registered: ‎11-29-2015
Accepted Solution

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


Accepted Solutions
Regular Visitor
Posts: 41
Registered: ‎11-29-2015

Re: Data source hosted on Dropbox

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} 

 


 

 

View solution in original post


All Replies
Super Contributor
Posts: 1,662
Registered: ‎12-15-2015

Re: Data source hosted on Dropbox

@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. 

 

Capture.PNG

 

 

 

Regular Visitor
Posts: 41
Registered: ‎11-29-2015

Re: Data source hosted on Dropbox

@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?a...

 

Thank you so much for your help!!!

 

 

Steven

 

 

Super Contributor
Posts: 1,662
Registered: ‎12-15-2015

Re: Data source hosted on Dropbox

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

 

Regular Visitor
Posts: 41
Registered: ‎11-29-2015

Re: Data source hosted on Dropbox

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} 

 


 

 

Frequent Visitor
Posts: 12
Registered: ‎02-09-2017

Re: Data source hosted on Dropbox

[ Edited ]

you dont need to give the /https://www.dropbox.com/ in the middle in the file path. 

you just need to give red color text as folder path as below 

 https://api-content.dropbox.com/1/files/auto/folder%20path%20Team%20Folder/OSO.xlsx?access_token=-dssgsgsfqertr

 

then it works in anomous login.

 

thanks,

Karthik

DN Member
Member
Posts: 140
Registered: ‎11-21-2016

Re: Data source hosted on Dropbox

Hi @ankitpatira.

 

this answer is using API v1, and it is no more supported by dropbox.

https://blogs.dropbox.com/developers/2016/06/api-v1-deprecated/

 

using API v2, could you please help list/view all files inside a folder?

using web query, I am having issue to make it work with my token and the link below.

https://api.dropboxapi.com/2/files/list_folder

Frequent Visitor
Posts: 3
Registered: ‎06-19-2016

Re: Data source hosted on Dropbox

[ Edited ]

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

DN Member
Member
Posts: 140
Registered: ‎11-21-2016

Re: Data source hosted on Dropbox

thanks for your suggestion, but my dropbox folder is already outside C:\...

It is in D:\.

The issue persists.

Frequent Visitor
Posts: 3
Registered: ‎06-19-2016

Re: Data source hosted on Dropbox

Make sure the file source path is similar to whoever access the files, like d:\Dropbox. I tried with my team it's working.