Question: how to extract data from excel to power bi?
Answer: Select the ellipsis from the upper-right corner of the visualization. Select Export data. ... 
From Export data, select Underlying data, and then select Export. Power BI exports the data.
When you select Export, your browser prompts you to save the file. Once saved, open the file in Excel.