Connect Github CVS to BI

[Anonymous]

How can i connect tis url 
csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_recovered_global.csv
to power bi and transform it as a table

[AllisonKennedy · Accepted solution]

You need to provide the whole URL. Try this M code as a starting point:

let
Source = Web.Page(Web.Contents("https://github.com/CSSEGISandData/COVID-19/blob/master/csse_covid_19_data/csse_covid_19_time_series/...")),
Data = Source{0}[Data],
#"Removed Columns" = Table.RemoveColumns(Data,{""}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Removed Columns", { "Province/State", "Country/Region", "Lat", "Long"}, "Report Date", "Cases"),
#"Added Custom" = Table.AddColumn(#"Unpivoted Other Columns", "Status", each "Recovered")
in
#"Added Custom"

[Anonymous]

You can generate a blank query and paste this code.

let
    Source = Csv.Document(File.Contents("pastyourURL.csv"),[Delimiter=",", Columns=7, Encoding=65001, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
  
in
 #"Promoted Headers"

If you import any CSV file, you can find the M code generated by the import and reuse it with its URL

My_PowerBI_Blog

[amitchandak]

@Anonymous , see if this can help

https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data/csse_covid_19_time_series