Question: how to connect powerbi to sharepoint excel file?
Answer: Open up PowerBI Desktop and on the home ribbon click Get Data. Highlight the SharePoint Folder and click Connect to continue.