To link an external data source, such as an Excel file located on a web page, to Power BI, you can follow these steps:
Open Power BI Desktop and select "Get Data" from the Home tab.
In the "Get Data" window, select "Web" from the list of available data sources.
In the "From Web" window, enter the URL of the web page where your Excel files are located and click "OK".
Power BI will retrieve the web page and display a Navigator window that shows the available files on the web page.
Select the Excel file you want to connect to and click "Load" to import the data into Power BI.
If you want to automate the process, you can create a query that pulls data from the web page and refreshes it on a regular schedule. To do this, click "Edit" in the "Navigator" window and create a new query using the "Transform Data" window.
Once you have created the query, you can schedule a refresh using the "Refresh" button on the Home tab. Click "Refresh Now" to refresh the data immediately, or select "Schedule Refresh" to set up a regular refresh schedule.
Note that if your Excel files are password-protected or require authentication, you may need to provide additional credentials in order to access them. Also, be aware that Power BI may have some limitations on the amount of data that can be imported from a web source.
