From the course: SharePoint Advanced: Working with PowerPivot
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Connect to external data sources
From the course: SharePoint Advanced: Working with PowerPivot
Connect to external data sources
- [Instructor] Something that you can already do with a pivot table is connect to other data sources, like SQL or Access database. Power Pivot does that, plus it adds a bunch of other options as well. Now, one word of caution, when you're adding data from other sources, you need to make sure that this is going to be something accessible to your eventual audience through SharePoint, or however else you're gonna share it with them. If you link to an SQL database that requires special authentication, well, it's gonna mess up that BI center that we're setting up. If you're not sure what databases you can safely link to, check with your system admin. I'm going to connect with an Access database. Once again, if you wanna follow along, you'll find this in the class files. Look for database_02_04. Now in a new worksheet, I've clicked onto the Power Pivot tab, now I'm gonna click manage, to bring up the power Pivot controls. In the from database, I'll click that and I'll say from Access. Click…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.