SEE: Here’s how to sync Microsoft Lists with Microsoft Excel ... where you cannot use SharePoint Lists, you can still get Power BI to connect to Microsoft Lists files. The solution just isn ...

How to configure an Excel file for use in Power BI Your email has been sent Getting viable data from an Excel workbook into Power BI for data visualization purposes takes some specific preparation.