Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to use web link from Kaggle to extract a .csv file using Web extractor?

Hello dear experts,   I'm trying to extract covid-19 real-time dataset from this below URL. But unfortunately, I'm not seeing a table in my Power BI - extract data pane, rather I see a .html input....
  • dzuurman's avatar
    dzuurman
    5 years ago

    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