Choosing the Import storage mode setting
So far in this book, we have imported a number of datasets, but we have not really broken down the steps to refine the process as we proceeded through the steps. Let's refresh our memory by looking at the various steps again, but this time highlighting the Import Data option:
- Open Power BI Desktop, and then click on Get Data | Excel.
- Select the
SSGSchool.xlsx
file to import. - Choose the tables you wish to import. In this case, we will select the tables we want by clicking on the squares next to each one to select them individually:
- Click on Load to import the dataset.
- You will see the Load screen, where the searched relationships are present, before importing:
- If you were importing any SQL connections, the following screen would appear...