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.

Learn how to use Microsoft Lists with Power BI using the SharePoint connector for quick and easy access to your data.