Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Get xlsx file from website

Hi guys,
I am trying to find solution how can i link external data source to PBI .
In my case my data is .xlsx file located on web page, and i have several of them.
So basically i need get excel files from web pulled in to PBI and have it automated, because this files refresh each day.
i have this (did use custom name to protect source
web page -



Regular Visitor

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.

Super User
Super User

That is sub optimal.  Would have been better if they Excel files were on a Sharepoint.


Can you do a folder contents listing on that web site, or do you know when which files appear?

Thank you for reply.
Data refreshes each day (mostly).
I was thinking using web scraping tool or something simillar. 
Basicly, i would like to automate it if possible. 
Automaticly download files to folder (sharepoing or local) and then PBI pulls them.

Talk to the website owner, maybe they can allow directory browsing for that folder.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors