Forum Discussion
How to use web link from Kaggle to extract a .csv file using Web extractor?
You have a few ways of doing this (as far as I'm aware) you can retrieve the download using something like a PHP/python script and extract the .csv to a location where you can subsequently have powerBI look for it. This I think is the only way other than downloading it yourself or by searching for a stream of data. I do see that he in Kaggle references to a source, from which he retrieves and edits the data. Perhaps looking at the source gives you a link that you can in fact use in powerBI
Helper IHi,
This is because that URL in fact is a link to a webpage and not directly to a .csv I cannot find a link directly to the CSV file on Kaggle and the download link on the page that your link currently goes to only retrieves a .zip.
Ok dzuurman , now I understood why this happened.
But how do I resolve this? How can I use this real-time data in my report?
Thanks,
Ambareesh.
- dzuurman
You have a few ways of doing this (as far as I'm aware) you can retrieve the download using something like a PHP/python script and extract the .csv to a location where you can subsequently have powerBI look for it. This I think is the only way other than downloading it yourself or by searching for a stream of data. I do see that he in Kaggle references to a source, from which he retrieves and edits the data. Perhaps looking at the source gives you a link that you can in fact use in powerBI