Dropbox

Workbooks or CSV's etc. We have drop box and are the company is not willing to switch to one drive. If we could have the same setup for one drive with drop box that would be awesome.

Any update on this? This would be a really useful feature if we can do a web connection to dropbox

Any update on this? We are looking at different BI tools and the dropbox function is a must - would it be possible to get an estimation on this feature (time or yes/no). I really like the "How can we improve Power BI", however, as for now I use it just to reference to what's possible and not in Power BI as I am a completely new user. I assume I wouldn't find many answers from dev team here? Having a two way communication would make "How can we improve Power BI" so much more useful (hopefully for both parties)...

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.

Major upvote for this. I've actually been trying OneDrive in lieu of Dropbox, but I'm sorry to say OneDrive is just a major pain-in-the-you-know-what, compared to Dropbox, and we aren't have anything luck with it.

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

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.

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!

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)

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.