Importing and Connecting OneDrive Files to Power BI

—Jourdan Strain |
Importing and Connecting OneDrive Files to Power BI
Jourdan Strain,

One of the key benefits of working in the Cloud is being able to access your most crucial data anytime, anywhere, and on any device. By importing and connecting your Excel, CSV, and Power BI Desktop files in OneDrive, you can rest assured that your data is always up-to-date.

Plus, it’s easy to connect OneDrive files to Power BI. Just follow these steps:

Getting Started

1. First, log in to Power BI.

2. On the Home screen, click Get Data.
Get Data

3. Under Files, click Get and then select OneDrive for Business.
OneDrive for Business

4. Find and select an Excel/CSV file from your OneDrive account.

5. Click Connect.
Connect

6. Choose to either Import or Connect your OneDrive file.

Importing OneDrive Files

Click Import. The data is stored in Power BI and allows you to query faster. Changes made in OneDrive are updated automatically.
Import

Connecting OneDrive Files

Click Connect. Connected files will be added to Workbooks, but the data itself remains in OneDrive. Edit data or make new graphs in Excel Online or in the desktop version—changes in the original file will also update here.
Connect

See—we told you it was simple. To connect or import more OneDrive files to Power BI, just repeat the steps outlined above.

Need more help with digital transformation? Get started with QuickHelp™.

Better known around the office as “The Queen of No,” Jourdan can actually be sort of pleasant once you get to know her. When she isn’t distracting the Marketing team with music video ideas, Jourdan is probably stalking the Barefoot Contessa, pretending (poorly) to enjoy exercise, or Netflix binging with her husband and goofball of a dog.
Insights
What is Change Management? Thoughts from an Expert
Alyce Adams, 07.03.19
Change management is a hot topic right now, and understandably so. But it’s a tough topic to fully wrap your head around. To shed further light on the subject, I recently sat down with an change expert: BrainStorm’s own Chandler Milne.
Read More
Culture
BrainStorm Principals John Wade and Eric Farr named Entrepreneur Of The Year® 2019 Award winners
Jourdan Strain, 06.20.19
EY announced that John Wade and Eric Farr of BrainStorm, Inc. received the Entrepreneur Of The Year® 2019 Award in the Business Services category in the Utah Region.
Read More
Product
Why PowerApps Is the New Game Changer at Work
Ruth Christensen, 07.30.19
You use a mountain of software applications at work. But you probably still ask, “Really? Shouldn’t there be an app for that?” Luckily, Microsoft PowerApps can help change that.
Read More