Forum Discussion
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}
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.
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.
Thank you so much for your help!!!
Steven
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}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}It works for me when I get a link from dropbox via vile explorer and when I paste the link I change "?dl=0" for "?dl=1". Then I can use the url in Power Query getting data from web.
"https://www.dropbox.com/s/je1pd9qmopp5t_____________rec2015.xlsx?dl=0" change it to "https://www.dropbox.com/s/je1pd9qmopp5t_____________rec2015.xlsx?dl=01"
I cold not make it work with a folder and haven't tried with the Power BI service. Hope it helps.
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.
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
