Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
---|---|
84 | |
81 | |
64 | |
53 | |
45 |
User | Count |
---|---|
100 | |
48 | |
41 | |
39 | |
38 |