Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am always grateful for your help.
I want to import data from a ZIP file (URL) on a website into PowerBI, but I don't know how to get the data, so please let me know.
thank you.
Solved! Go to Solution.
Hi @Tome_05 ,
Please refer the solution in this post.
Solved: Import a zipped csv file from web url - Microsoft Power BI Community
Best Regards,
Jay
Hi @Tome_05 ,
Please refer the solution in this post.
Solved: Import a zipped csv file from web url - Microsoft Power BI Community
Best Regards,
Jay
Hi @Tome_05 ,
You can use the R script editor to download the file and then read it in.
Something like this should work:
library(RCurl)
url <- "http://example.com/file.zip"
tempfile <- tempfile()
download.file(url, tempfile)
unzip(tempfile)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |