Get ready and keep an Excel file you want to load in an accessible location.
Launch PowerBI and click Get Data handle. The first submenu item is EXCEL.
Click Excel. In the Open dialog browse and locate you EXCEL file (*.xlsx).
Click Open and the Navigator is displayed with the SampleExcel.xlsx file. It has only one sheet with a default name. In a real case you may have multiple sheets.
Click Sheet1. The data gets loaded on to the right pane as shown. There is an Edit button we will take it up later. The Navigator has all the columns on the original EXCEL sheet as shown.
Click Load and the data gets loaded into PowerBI. Click the 'table' on the left pane (the data is in the center pane). The data is shown in a tabulated fashion as shown.
That's all! It's like 1-2-3
Launch PowerBI and click Get Data handle. The first submenu item is EXCEL.
Click Excel. In the Open dialog browse and locate you EXCEL file (*.xlsx).
Click Open and the Navigator is displayed with the SampleExcel.xlsx file. It has only one sheet with a default name. In a real case you may have multiple sheets.
Click Sheet1. The data gets loaded on to the right pane as shown. There is an Edit button we will take it up later. The Navigator has all the columns on the original EXCEL sheet as shown.
No comments:
Post a Comment