Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

R script to import multiple files

Hi everyone

I have this R code below which is importing into Powerbi a data from a one single zip file. I am wondering if I have multiple files that I needed to import.  How can I do that?

 

#create temp file

temp <- tempfile ()

#download zip archive to temp file

urlzipArchive = “https://github.com/CriticalPathTraining/PBI365/tree/master/Student/Data

download.file (urlzipArchive ,temp)

#extract csv file out of zip

csvFile = unz(temp, “SalesByCustomer.csv”)

#load new data frame from data in CSV file

customers <-read.csv(csvFile)

#perform cleanup

unlink (temp)

remove (csvFile)

remove(temp)

remove(urlzipArchive)

2 REPLIES 2
V-lianl-msft
Community Support
Community Support

Syndicated - Outbound

Hi @Anonymous ,

 

Sorry, not very proficient in R script.

See if this can help you:https://www.edureka.co/community/1902/how-can-i-import-multiple-csv-files-into-r 

 

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

avatar user
Anonymous
Not applicable

Syndicated - Outbound

Hello @V-lianl-msft  thanks .

I wil try this code and let you know

 

Thanks 

avatar user

Helpful resources

Announcements
FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)