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.

Power BI will then connect to the SharePoint site and allow you to select the Excel file you want to import. Once connected, you can import data from specific sheets or tables within the Excel file ...

The April 2016 Power BI Desktop update introduced a new way of getting data from Excel files stored in SharePoint: the SharePoint Files data source, based on the SharePoint.Files () M function.