179
Connect to workbooks that are stored in Dropbox
STATUS DETAILS
Under Review

Comments

P

Connecting to Dropbox from a web gateway with anonymous credentials (key in url) throws the error "Failed to update data source credentials: Web.Contents failed to get contents from"
Connecting to Dropbox from PowerBI Desktop works.

It would be nice to have an easy to use connector, but I would be happy with any method that works right now ;).

P

Any update on this? Although it is working for Power BI Desktop, there is no available solution for Power BI service yet...

P

Try these tutorial, from the MVP Imke Feldman:

http://www.thebiccountant.com/2017/06/25/import-multiple-files-dropbox-folder-powerbi-excel-via-powerquery-at-once/#comment-695

Works to me.

P

This works for files, but not for folders. The abilty to query a whole folder is critical. There is code out there that works for excel/powerquery but errors in PBI Service

P

we would like to be able to connect Power BI to our dropbox as well. Please let us know if this is something you are working on.

P

You can still do this with Dropbox v2, at least in Power BI Desktop (haven't tried in web)
Basic steps
- Create an app at http://www.dropbox.com/developers
- Go here: https://www.dropbox.com/developers/documentation/http/documentation#files-download
- In the example on that page, you will see a live link to "get access token". Click it.
- In power bi, create a Web data source, and switch to advanced mode
- The URL is: https://content.dropboxapi.com/2/files/download
- Add header: Authorization, with the value "Bearer " (without quotes)
- Add header: Dropbox-API-Arg, with the value { path: "path\to\your\file.xlsx" }
- Once the data loads, right click the blob you see in the query editor, select "Excel", and it's all good.

The direct function if you want to skip the UI is:
Excel.Workbook(Web.Contents("https://content.dropboxapi.com/2/files/download", [Headers=[Authorization="Bearer ", #"Dropbox-API-Arg"="{""path"": ""/Your/Path.xlxs""}"]]), null, true)

P

While researching this topic, I noticed that all the examples given (in community forums) appear to be for the Dropbox v1 API, which has been deprecated and will be turned off in a few months (June 2017):

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

The v2 API looks much more complex - there doesnt appear to be any direct equivalent for the method suggested above (single HTTPS call with an API Key). The authentication requirements now seem more complex:

https://www.dropbox.com/developers/reference/auth-types#user

It's stumped me - I hope the direct integration can be added soon!

P

I think it's a very clear to power bi team connecting to dropbox is very important!
Any update?

P

Any update?? I have lots of excel files in Dropbox that I need to use in Power BI. Please let us know when it is ready.

P

YES!!! The ability to read a CSV file in a dropbox is very important to us too. Right now, this is the only way we can access our CSAT scores to put them on a dashboard.