Covid Github data not refreshing with new columns

[samgreene1]

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 edit my query and go back to the source step, I still don't see these new dates.  Opening the url in a browser shows the new dates.  Any ideas what I'm doing wrong?  Will power bi not check for new columns when refreshing data? 

Thanks,

Sam

Here's an example: 

let
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]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Promoted Headers", {"Province/State", "Country/Region", "Lat", "Long"}, "Attribute", "Value"),
#"Renamed Columns" = Table.RenameColumns(#"Unpivoted Other Columns",{{"Attribute", "Date"}}),
#"Changed Type2" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date", type date}}),
#"Renamed Columns1" = Table.RenameColumns(#"Changed Type2",{{"Value", "Confirmed Cases"}})
in
#"Renamed Columns1"

[Anonymous]

@samgreene1 

Thank you for asking this! I was having the same issue in my own Power BI report that I am creating.

Thanks for the insightful answer, @Greg_Deckler !

[Greg_Deckler · Accepted solution]

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

[samgreene1]

Many thanks!  That worked!

[Greg_Deckler]

Yeah, not sure why not excluding the number of columns is not the default. Comes up a fair amount.