In this section, we show you how to connect Power BI to Excel files and how to get data from Excel to Power BI. To demonstrate how to Get Data from Excel to Power BI, we will upload the data from the Excel file to Power BI and generate a donut chart.
How to get data from Excel to Power BI
Before we begin, let's look at the data present in the Excel file of sales by country. In the screenshot below, you can see that the first row has the column names.
<>If you haven't started Power BI Desktop yet, double-click Power BI Desktop to open it. Once it's open, it looks like the screenshot below. Click on the Get information Hyperlink.
If you are on the Power BI visualization page, on the Home tab, click the Get information option and select the Standing out as we show below. Or select More options.
Get data from Excel to Power BI
When you select the More option, the following window will be displayed. You can use this window to select the data source you want. For now, let me select the File -> Standing out Option and click Connect button
Once you click on the Connect , a new window opens to select the Excel file from our file system. For now, we are selecting the SalesByCountry.xls file, as shown below.
Expanding the Excel folder displays the list of available sheets. If you select the sheet or table, it displays the Data Preview. In the screenshot below, you can see the preview of the sheet.
If you are satisfied with the data and data types, click the Upload button. Otherwise, click the Edit button to make changes.
Currently, we do not want to make any changes to the data. So let me click on the Load button
Please wait until the upload is complete
Now you can see all the columns that were imported from the Excel file in the Fields section.
Let me create a donut chart with this data. I suggest you check out the Power BI Donut Chart article to understand the steps required to create it.
