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