With Power BI Desktop, you can connect to many different types of data. These sources include basic data sources, such as a Microsoft Excel file. You can connect to online services that contain all sorts of data, such as Salesforce, Microsoft Dynamics, Azure Blob Storage, and many more.
- To connect to data, from the Home ribbon select Get Data.
The Get Data window appears. You can choose from the many different data sources to which Power BI Desktop can connect.
Since this data source is an Excel file, select Excel from the Get Data window, then select the Connect button.
Power BI prompts you to provide the location of the Excel file to which to connect. The downloaded file is called Financial Sample. Select that file, and then select Open.
Once you've made your selections, select Load to import the data into Power BI Desktop.