From the course: Learning Power BI Desktop [Update]

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Connect to a file: Excel

Connect to a file: Excel

From the course: Learning Power BI Desktop [Update]

Start my 1-month free trial Buy for my team

Connect to a file: Excel

“

- [Instructor] We're going to begin by grabbing some data from Microsoft Excel. If you're working along with me, pause the movie now and download and extract the exercisefiles.zip archive from the landing page for this course if you've not done so already. My preference would be that you extract the exercise files to your OneDrive for Business, create a folder for them. I named mine Power BI Desktop Exercise Files. But wherever you put them, make sure you know where it is 'cause you'll need to know that location in a minute. I want to bring in data from an Excel workbook, so I'm going to click Excel workbook here. I could also have clicked it down here on this tile. Same thing. And if I go into my exercise files in chapter two, I will find this Excel workbook named MedianAge.xlsx, and I'm going to click Open. The navigator is going to open and load a preview of this workbook. Not everything from the workbook, but some information. At the top what we see are the sheets in the workbook.…

Contents