Forum Discussion
Conecte Powerbi a Github
Estoy tratando de cargar un repositorio github en powerbi ( https://github.com/Laila92/COVID-19/tree/master/csse_covid_19_data)
Seguí este tutorial (https://thinkaboutit.be/2018/03/connect-to-github-microsoft-al-with-power-bi/) , y soy capaz de conectarse al repositorio de Github, pero no ver los datos reales. En cambio, veo como cuántas personas contribuyeron.
¿Cómo puedo cargar los datos reales en Powerbi?
3 Replies
Hola @Laila92 ,
Podemos crear una consulta en blanco y usar la siguiente consulta en Advanced Editor para satisfacer sus requisitos:
let Source = List.Dates(#date(2020,1,22),Duration.Days(DateTime.Date(DateTime.LocalNow())-#date(2020,1,22)),#duration(1,0,0,0)), #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Added Custom" = Table.AddColumn(#"Converted to Table", "Custom", each Date.ToText([Column1],"MM-dd-yyyy")), #"Added Custom1" = Table.AddColumn(#"Added Custom", "Custom.1", each Table.PromoteHeaders(Csv.Document(Web.Contents("https://raw.githubusercontent.com",[RelativePath="/Laila92/COVID-19/master/csse_covid_19_data/csse_covid_19_daily_reports/"&[Custom]&".csv"]),[Delimiter=",", Columns=6, Encoding=65001, QuoteStyle=QuoteStyle.None]),[PromoteAllScalars=true])), #"Removed Errors" = Table.RemoveRowsWithErrors(#"Added Custom1", {"Custom.1"}), #"Expanded Custom.1" = Table.ExpandTableColumn(#"Removed Errors", "Custom.1", {"Province/State", "Country/Region", "Last Update", "Confirmed", "Deaths", "Recovered"}, {"Province/State", "Country/Region", "Last Update", "Confirmed", "Deaths", "Recovered"}) in #"Expanded Custom.1"Consulte también este hilo similar: https://community.powerbi.com/t5/Desktop/Get-data-from-web-cannot-bring-the-table/td-p/974083
Saludos¡Esa es una gran solución! Sin embargo, sólo está extrayendo datos de 1/22/2020 - 3/18/2020.
Por lo tanto, he cambiado la ruta relativa en su código para ir directamente al github johns Hopkins:
let Source = List.Dates(#date(2020,1,22),Duration.Days(DateTime.Date(DateTime.LocalNow())-#date(2020,1,22)),#duration(1,0,0,0)), #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Added Custom" = Table.AddColumn(#"Converted to Table", "Custom", each Date.ToText([Column1],"MM-dd-yyyy")), #"Added Custom1" = Table.AddColumn(#"Added Custom", "Custom.1", each Table.PromoteHeaders(Csv.Document(Web.Contents("https://raw.githubusercontent.com",[RelativePath="/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data/csse_covid_19_daily_reports/"&[Custom]&".csv"]),[Delimiter=",", Columns=6, Encoding=65001, QuoteStyle=QuoteStyle.None]),[PromoteAllScalars=true])), #"Removed Errors" = Table.RemoveRowsWithErrors(#"Added Custom1", {"Custom.1"}), #"Expanded Custom.1" = Table.ExpandTableColumn(#"Removed Errors", "Custom.1", {"Province/State", "Country/Region", "Last Update", "Confirmed", "Deaths", "Recovered"}, {"Province/State", "Country/Region", "Last Update", "Confirmed", "Deaths", "Recovered"}) in #"Expanded Custom.1"Pero hay algún problema. Después de cargar los datos en el Editor avanzado, aquí está el resultado. Sin datos:
¡Agradecería cualquier ayuda! Gracias.
-Stephen
