Data Connection

[clarkar07]

I had connected to this data originally when it was stored in the google doc via Microsoft PowerBI, just using the built in "Get Data - Web Connection."

When the data feed moved to git hub I just started pointing PowerBI to the most recently updated csv file.

It seems that method is no longer working, either, and instead of a table of data PowerBI is pulling in just some snippets of html code, and not the data table. If anyone has some suggestions where I've went wrong I would appreciate it.

[dawenx]

@clarkar07 this is b/c they renamed folders and moved things around a couple hours ago

[CSSEGISandData]

Hello, we were maintaining and updating our GitHub early today. We will keep collecting the data and make it public. Sorry for the sudden change if that causes any inconvenience for you. Thanks

[Sitius86]

@clarkar07
I was having the same issue (also using Power BI previously hooked to Google sheets and then the V1 Github endpoints). Power BI needs to point to the "Raw" csv endpoint, not the HTML table. Just update your web address in your query to:

https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_19-covid-Confirmed.csv

And then replace "Confirmed" with "Death" and then "Recovered", and then append the three tables together.

So the first query step (Source) will be:

= Csv.Document(Web.Contents("https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_19-covid-Confirmed.csv"),[Delimiter=",", Encoding=65001, QuoteStyle=QuoteStyle.None])

[Wilkus]

Thanks to whoever has been updating the files here, I've graphed the progress that I posted at https://twitter.com/sawilkus/status/1233549303215464449?s=20
(with a reference to this source).
Thank you again.
It's encouraging to see the number of new recoveries exceed the number of new cases and the death rate has dropped to 1.5% of the recovery rate.