Not able to connect Power BI Desktop with Dropbox

[ricky23]

I have an excel spreadsheet in Dropbox that I would like to load in the Power Bi Desktop. I am not able to connect Power BI Desktop with Dropbox.

This is what I did-

I created an app in Dropbox and then generated an app token that has access to all the folders in Dropbox.

Then I used the Web Connector in the Power BI Desktop with the v2 API URL

URL: https://content.dropboxapi.com/2/files/download

HTTP Header

Authorization : Bearer api_token

Dropbox-API-Arg : {\"path\": \"/folder/file.xslx\"}"

O

Once I click on Ok, I get a 400 Error that says "Web.Contents failed to get contents from 'https://content.dropboxapi.com/2/files/download' (400): Bad Request"

Any help on this matter would be greatly appreciated.

[v-sihou-msft]

@ricky23

You can just append the api token into your URL string. Please refer to similar thread below:

https://community.powerbi.com/t5/Desktop/Data-source-hosted-on-Dropbox/td-p/47882

Regards,

[ricky23]

@v-sihou-msft  Thanks for your reply! I have tried that method of appending the Access Token with the URL but I still get an error. Please see the screenshot below-

I tried using the same URL on a browser and I get a message that the v1 api is deprecated.

 

This URL would have probably worked if the v1 API of Dropbox is still active but unfortunately it's not. Dropbox is now using the version 2. 

Kindly help