MS Excel — Connecting PowerQuery To An Excel File In The Cloud (OneDrive) — Part 3

Microsoft’s Cloud Service Is Next Up for My Cloud Excel File Data Acquisition…

Image for post
Image for post
Excel File in Microsoft OneDrive

Knowing how to retrieve data directly Excel files from these cloud services comes in very handy!

In Part 1, I explored accessing Excel files in Box.com.

Here’s The Process for Excel Files in Microsoft OneDrive

Locate the Excel file in OneDrive.

Image for post
Image for post
Excel File in Microsoft OneDrive Folder
Image for post
Image for post
Right-click the file and select “Download
Image for post
Image for post
Downloads page of the Chrome Browser — Copy associated Link
Image for post
Image for post
Excel 2016 “Data >> Get & Transform Data >> From Web”
Image for post
Image for post
Paste Link — DELETE text string subsequent to the Excel file extension
Image for post
Image for post
Select Data source and Click Edit in Query Navigator window
Image for post
Image for post
Edit Query Settings to change the query name.
Image for post
Load Data — select “File >> Close & Load To…”
Image for post
Image for post
Load data into an Excel Worksheet
Image for post
Image for post
Microsoft OneDrive sourced data loaded into the Excel Spreadsheet!

About Don

Image for post
Image for post

“It’s time for different”

Connect with Don!

LinkedIn, Flipboard, Twitter, Snapchat

It’s time for DIFFERENT— On a mission to challenge the status quo to a more productive and effective end… #digital #Excel #data #analytics

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store