#What is a dropbox workbook code#

Make sure you always begin with a slash like this: “/Subfolder”. Nested subfolders will be accessed like this: /Subfolder1/Subfolder2″. You can create sub-folders in the main folder and to access them, you just pass the string into the second function field “Folder”. Table.PromoteHeaders( Csv.Document() ) Sub-Folders If you open csv-files, their first rows will not be headers by default. If you wrap the opening-function: “Csv.Document” into a “Table.PromoteHeaders”, they will behave: This is “Excel.Workbook” for xlsx-files and for other files formats check out the functions here.

To open them, you create a column where you open them with the appropriate function. The files come in the column “File” as a binary.

#What is a dropbox workbook code#

The code for it I’ve got from this thread in the PowerBI forum, which contains some additional useful information and a link to a solution with a custom connector for PowerBI, making it easy to deploy in a corporate environment (designed by Igor Cotruta).ġ Open your Dropbox and to to settings 2 Scroll down and choose “Developers” 3 Select “My apps” and click “Create app” 4 Choose “Dropbox API” -> “Full Dropbox” -> And give it a nice name 5 Simply click on “Generate”, copy the token and save it for later useĦ Download the “fnDropboxFolder”-file and copy the contentįnDropboxFolder 7 Open pbi and create a new blank queryĩ Check all content there and replace it with the copied codeġ0 Paste your API-token into the first field of the function dialogue To make it super-easy for you, I’ve created a function that you can download here: So also all those people who you’ve sent this beautiful dashboard where you just forgot that it contained your token…

I will present the folder-method, as granting access to your whole Dropbox is really dangerous in my eyes – unless you are prepared to share it all publicly: The token generated will allow anyone to read your data. There are 2 different methods to grant access to your Dropbox: Grant access to the whole Dropbox or to a (newly created ) folder only. Edit 2nd October 2021: Unfortunately this method doesn’t work any more, as Dropbox now requires proper OAuth authentication.īelow you’ll find a video where you can see how easy it is to import multiples files from a Dropbox folder into PowerBI or Excel at once.