PowerQuery Connection to COVID-19 Data on GitHub Get and Transform

Matt Mickle 

Hi Matt,

You may use direct link on the file, add date as parameter

let
    Source = Csv.Document(
        Web.Contents(
            "https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_daily_reports/03-22-2020.csv"
        ),
        [Delimiter=",", Columns=8, Encoding=65001, QuoteStyle=QuoteStyle.None]
    ),
    #"Promoted Headers" = Table.PromoteHeaders(
        Source,
        [PromoteAllScalars=true]
    ),
    #"Changed Type" = Table.TransformColumnTypes(
        #"Promoted Headers",
        {
            {"Province/State", type text},
            {"Country/Region", type text},
            {"Last Update", type datetime},
            {"Confirmed", Int64.Type},
            {"Deaths", Int64.Type},
            {"Recovered", Int64.Type},
            {"Latitude", type number},
            {"Longitude", type number}
        }
    )
in
    #"Changed Type"

Another sample of using this source is here https://datachant.com/2020/03/18/covid-19-build-your-own-power-bi-dashboard/