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.

These allow you to connect with data that exists within a SharePoint list, Excel Services Document or SQL Server Analysis Services data.