Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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 |
---|---|
94 | |
92 | |
85 | |
83 | |
49 |
User | Count |
---|---|
150 | |
146 | |
112 | |
73 | |
56 |