Forum Discussion

samgreene1's avatar
samgreene1
Icon for Resolver II rankResolver II
6 years ago
Solved

Covid 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 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_time_series/time_series_19-covid-Confirmed.csv"),[Delimiter=",", 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"

4 Replies