Data from the Excel file appears. The data needs to be cleaned and formatted before loading into Power BI. Click on the Transform Data button, as indicated by the bottom red arrow in the “Transaction ...

Microsoft’s Power BI Desktop, integrated with Excel, offers a powerful solution for transforming data into rich, interactive dashboards.

Excel isn't going away, but it's going to stop accumulating extra tools like barnacles. Instead Power BI Desktop will become the self-service analytics hub.

Microsoft is finally giving businesses what they really want: data types based on their own customer data.

You can publish an Excel file to Power BI to share with others, analyze a Power BI dataset in Excel, or import Excel data or an entire workbook into Power BI for powerful visualizations.