Importing and Connecting OneDrive Files to Power BI

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

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.

Getting Started

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

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

3. Find and select the file from your OneDrive account.

4. Click Connect.
Connect

5. 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

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
Memes In TEAMS: How to Rule the World in 1 Click
Ruth Christensen, 04.18.19
Just in case you’ve only taken the macro view of MS Teams, know this: You can now create your own meme in Teams. That’s right—Teams has a built-in meme tool. With a simple click of the mouse, you can rule the workplace and bask in the glow of your awesomeness.
Read More
Culture
Silicon Slopes partners with BrainStorm, Inc. to launch Silicon Slopes Serves Initiative
Jourdan Strain, 02.07.19
Silicon Slopes has partnered with BrainStorm, Inc. to launch Silicon Slopes Serves. Silicon Slopes empowers Utah's startup and tech community to learn, connect and serve. The Silicon Slopes Serves initiative is another step on Silicon Slopes' path to ramp up its mission to serve.
Read More
Product
BrainStorm Achieves Microsoft Silver Cloud Platform Competency
Jourdan Strain, 09.14.18
Microsoft Silver Cloud Platform competency is a recognition given only to those partners who specialize in building, integrating and/or extending solutions or infrastructures using the Microsoft Azure cloud platform.
Read More