Question: how to connect power bi to sharepoint excel file?
Answer: In Power BI, in the nav pane, click Get Data. In Files, click Get. Find your file. If your workbook file is on OneDrive or SharePoint - Team Sites, choose Import or Connect.