How to Load multiple csv files From website to Power BI desktop

[BILearnerToday]

Hi All,

I have a website that has published multiple CSV files and I would like to load them to a new Power BI desktop, they have the same format (same amount of fields).  The files look like they are saved on dropbox and then published on the website.

Kindly advise and thanks in advance

Step 1 access the website which has www. .....

Step 2 load each CSV file from the website to the Power BI desktop,

Step 3 combines all these CSV files into one file using the Power BI query editor 

[Anonymous · Accepted solution]

Hi @BILearnerToday ,

It is not possible to directly connect to the CSV file in Web. As a workaround, you can store the CSV file in OneDrive or SharePoint or local disk. 

About connecting to multi CSV files from online, you may try to connect to SharePoint folder.

More details you can refer to:

Power Query SharePoint folder connector - Power Query | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.