Scheduled refresh of Dropbox file obtained by API v2 URL (no headers, etc)

[agagatsis]

Hello everyone. 

I have a dashboard loading data from a dropbox file, using the API v2's URL:

= Excel.Workbook(Web.Contents("https://content.dropboxapi.com/2/files/download?authorization=Bearer%20MYACCESSKEY&arg={""path"":""/...""}"), null, true)

The authentication method is set to Anonymous. Pressing refresh works without any issues in Power BI desktop, but on Power BI service, I get an authentication error, claiming my credentials are wrong. There are no other arguments passed in any way in the Desktop app, just what you see above. Thus what makes the two uses different and how can I refresh my data from Power BI service (even manually, not with scheduled refresh)?

Thank you.

[v-yuta-msft · Accepted solution]

@agagatsis ,

Currently there's no dropbox connector which is supported by power bi service. However, there's a workaround, please refer to similar case below:

https://community.powerbi.com/t5/Power-Query/Power-BI-service-and-Dropbox/td-p/389595

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.