Getting viable data from an Excel workbook into Power BI for data visualization purposes takes some specific preparation. Here is what you need to do.

First, sign into your Microsoft account and then launch Power BI. Next, you need data, and in Power BI you can import data from many sources, including Excel workbooks (Figure B).

Learn how to import, clean, and transform external data in Excel using Power Query. Simplify workflows and master data analysis today ...