For Power BI

1) Take a new page.
2) Select get data from the Home tab
3) Then choose the data source you wish to like.

and fill the following section and then visualize your report.

for further information, please click the link mentioned below,
Each and everything is mentioned in detail.

https://docs.microsoft.com/en-us/power-bi/create-reports/service-from-excel-to-stunning-report