Question: how to import excel file from sharepoint to power bi?
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.