This is an excerpt from Power BI, the latest computer course released by Velsoft Training Materials. The courseware shows learners how to link and model data in Power BI and create visual reports that reveal data insights.

Your first step after creating a Power BI file will be to connect your data to it. We will cover the two most common scenarios (Excel workbooks and Access databases) and show you where to find additional options if you need them. We will also discuss creating a manual data set and managing data sources.

Topic Objectives

In this section, you will learn:

  • How to connect to an Excel workbook or Access database
  • How to view all connection options
  • How to create a manual dataset
  • How to manage data sources

Connecting to an Excel Workbook

To connect to an Excel workbook, open the target Power BI file. (Here, we are starting from a new file.) Click Home → Get Data arrow → Excel:

Power BI Data Sources

Instructor Tip: Note that there is a separate option for text and CSV files.

The Open dialog will appear. Navigate to your file, select it, and click Open:

Power BI Data Sources

Next, the Navigator will appear. On the left side, check the items you want to load into the current Power BI data model. (You can also click any item to preview it.) Click Load when you are ready:

Power BI Data Sources

Your data will then be loaded. You can view it by clicking the Data icon in the navigation pane:

Power BI Data Sources

You can change the table currently being displayed by clicking any item in the Fields pane on the left side of the window.

Connecting to an Access Database

To connect to an Access database, click Home → Get Data:

Power BI Data Sources

You will now see a list of all connection options. Click “Access database” to select it and then click Connect:

Power BI Data Sources

Just as before, the Open dialog will appear. Navigate to your file, select it, and click Open:

Power BI Data Sources

Next, the Navigator will appear. On the left side, check the items you want to load into the current Power BI data model. (You can also click any item to preview it.) Click Load when you are ready:

Power BI Data Sources

The data will now be loaded and will be accessible via Data view, just as when we imported an Excel workbook.

Viewing All Connection Options

Let’s take a closer look at the Get Data dialog, which appears when you click Home → Get Data:

Power BI Data Sources

Simply choose a source from the list on the right and click Connect to see the related options for specifying details about the source. On the left side, you can use the categories or the search field to narrow down the list on the right.

Creating a Manual Dataset

If your data does not yet exist, you can create a manual dataset that will be stored within Power BI. To start, click Home → Enter Data:

Power BI Data Sources

The Create Table window will appear:

Power BI Data Sources

To start, rename the table columns by double-clicking them. (You should also enter a table name in the field at the bottom of the dialog.) Then, enter your data into the table. (You can add more rows by pressing the down arrow key from the last row, and more columns with the right arrow key from the last column.) Once your data is entered, click Load to complete the process:

Power BI Data Sources

The table will now be added:

Power BI Data Sources

Managing Data Sources

To manage the data sources in a Power BI file, click Home → Edit Queries drop-down arrow → Data source settings:

Power BI Data Sources

Here, you can view and edit the data sources currently connected to this file:

Power BI Data Sources

 

Find out more about Velsoft’s Power BI course here.