Microsoft Idea

Andreu fil on 19 Apr 2024 11:02:42

RE: Dropbox

Good information, thankssehackear.top

Jon Webster on 05 Jul 2020 23:44:37

RE: Dropbox

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 ;).

Power BI User on 05 Jul 2020 23:17:12

RE: Dropbox

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

Hugo Venturini on 05 Jul 2020 23:05:51

RE: Dropbox

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.

Power BI User on 05 Jul 2020 22:56:13

RE: Dropbox

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

Greg on 05 Jul 2020 22:54:58

RE: Dropbox

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.

Richard Wilson on 05 Jul 2020 22:48:08

RE: Dropbox

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)

Mike Honey on 05 Jul 2020 22:42:00

RE: Dropbox

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!

Power BI User on 05 Jul 2020 22:34:44

RE: Dropbox

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

Power BI User on 05 Jul 2020 22:34:42

RE: Dropbox

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.