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.

Figure A: We’ll add sparklines to this simple sheet of data imported from an Excel .xlsx file. To import this data, launch Power BI as you normally do, and close the information window.