1st open power BI desktop in your system == Select Blank Report
Righ click that excel > Go TO Info . Copy path
After
removed extra think from url we will use the same url to access the excel.
Select Home Tab > Get data > Web
Paste url and click ok
If Everything is ok you can below screen.
Select the sheet you want and click the Load button
After successfully the data is view as per below window
Select the data you want. When you choose the fields, they are automatically populated on the screen.