Getting data from a file, such as Excel, CSV, XML, or text, is the most straightforward method of getting data into Power BI. We'll start here with an Excel file. Download and install the Power BI Desktop from www.PowerBI.com before you begin.
Your Power BI Desktop may look a little different than mine, based on when you downloaded it, although the foundation will remain the same. A new version is released every month.
Our goal here is to solely connect the data in an Excel file to the Power BI Desktop and import the data into the in-memory data model for Power BI. This will allow the data to reside in Power BI for use with its many visuals: