MS Excel — Connecting PowerQuery To An Excel File In The Cloud (Box.com) — Part 1

The More You Work With Data, You Will Want This!

Image Credit: https://box.georgetown.edu/

As a finance and accounting professional, I spend a lot of time working with data.

Increasingly, I also get to deal with cloud data across many various cloud storage services —primarily Box.com, Dropbox, OneDrive and GoogleDrive. So knowing how to retrieve data directly Excel files from these cloud services comes in very handy!

The first one I am going to tackle is Box.com

Here’s The Process

Locate the Excel file in Box (web version) and share a link.

Excel File Located in Box

Turn on Link Sharing — “People with the Link”

Click on “Link Settings” and make the following selections.

Click Link Settings

Verify Link Settings Match the Above — and COPY the Direct Link

Open a new Excel workbook, create a WEB connection via Power Query (or Get & Transform in Excel 2016).

Paste the URL to the Box file and your connection is setup.

Select Tab, Connection is Completed

You are now ready to scrub and modify your data set!

That’s it!

Next up? Connecting to a file in GoogleDrive!

About Don

“It’s time for different”

Connect with Don!

LinkedIn, Flipboard, Twitter, Snapchat