Question: how to import data from excel in 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.