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.