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.