Forum Discussion
samgreene1
Resolver II
Resolver IICovid Github data not refreshing with new columns
Hi, I am pulling data from Github regarding Covid. When I refresh the data, it doesn't seem to update in Powerbi. There should be new columns for recent dates added to the end of lines. If I ...
You need to edit this line:
Source = Csv.Document(Web.Contents("https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_ti...",", Columns=63, Encoding=65001, QuoteStyle=QuoteStyle.None]),
You can get rid of that entirely I believe to make it recognize new columns
Greg_Deckler
Community Champion
Community ChampionYou need to edit this line:
Source = Csv.Document(Web.Contents("https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_ti...",", Columns=63, Encoding=65001, QuoteStyle=QuoteStyle.None]),
You can get rid of that entirely I believe to make it recognize new columns
samgreene1Resolver II
Resolver IIMany thanks! That worked!
- Greg_Deckler
Yeah, not sure why not excluding the number of columns is not the default. Comes up a fair amount.