Join Bill Kulterman for an in-depth discussion in this video Exercise files, part of SharePoint 365: Integrating with PowerBI.
- [Instructor] Hi, before you begin this course, you're going to need to download the exercise files to your desktop and then place them in a folder called Exercise Files, like I have here. If we open the folder, you'll see that there are four exercise files in there. It's four Excel workbooks, and we're going to start by uploading three of them into our documents library on our SharePoint site. The fourth one, we'll take a look at what to do with in just a little bit. So let's go ahead and go to our SharePoint now. Okay, we're here in our SharePoint document library, and we want to upload three of those exercise files.
So we're going to click on the Upload button, select Files. It's opened up to my desktop. If it hasn't opened up to your desktop, navigate to that. Go through the Exercise Files folder, and choose, by holding down your Control key and selecting on each one, these three files, Annual Expenses, Hotel Revenue, and Occupancy. We'll click the Open button, and we'll see that all three of our workbooks have been uploaded to our SharePoint document library.
Now let's go ahead and go to the Hotel Info. This is a SharePoint list that I have created, called Hotel Info. All of the information in this list exists in that fourth Excel workbook. Let's go ahead and open that up and take a look at it. As you can see, there's not a lot of data in this list, and what you will need to do is manually enter it into that SharePoint list, which I have renamed Hotel ID.
Once you have all of that stuff in place, you'll be ready to go. You will be able to use the Annual Expenses file in the movie Connect To Data In A SharePoint Folder. You'll need the exercise file Hotel ID for the movie Connect To A SharePoint Online List. You'll need the exercise file Occupancy for the movie Data Sources In Power BI Services. And you'll need the final exercise, Hotel Revenue, for the movie Combine From SharePoint.
- Connecting to data in libraries, lists, services, and more
- Adding custom columns
- Editing queries
- Creating charts and other visualizations
- Combining data from multiple sources
- Managing relationships between data
- Publishing reports to Power BI services
- Embedding reports on SharePoint pages