Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
jmg80525
Helper II
Helper II

How to load individual CSV files from URL

Greetings:

Looking for a little insight to see if I can combine CSV files that are publically exposed on a web page.  (https://ecmc.state.co.us/data2.html#/downloads under the Production Data>All Production Reports Received By Year).  Each CSV has a URL link where the link will only differ from one year to another by the year itself.  I understand I could download the files into a folder with Power Flow and then use the Folder.Connect function, but I was hoping to bypass that step and build a dataflow that combines all the CSV files with a single transformation. Something with a table or parameters that would loop through the year domain and continue to load the CSV files into a single query.  Thanks in advance. 

1 REPLY 1
MattAllington
Community Champion
Community Champion

To complete a file combine you need an address for the source files and a list of file names. If you are doing file combine from your pc, PQ can generate the list of files for you. You may or may not be able to generate the list of files from the web, you have to check it out. Just

get file

from web

when the wizard launches, right click the yellow folder icon in the wizard and select "transform data". If the list of files isn't available, you can create one yourself or load one from Excel. This assumes you know the file names, of course. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors