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)