Open Djtrip83 opened 4 years ago
Share it, there is not harm on doing it. People can feel free to pick it up
I created a Power BI script to pull all Daily Report CSVs at once in a loop. Not sure if this is the right place to share but if interested let me know.
I am interested.
that would be great
On Wed, Apr 1, 2020 at 1:13 PM Mpicca notifications@github.com wrote:
I created a Power BI script to pull all Daily Report CSVs at once in a loop. Not sure if this is the right place to share but if interested let me know.
I am interested.
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/CSSEGISandData/COVID-19/issues/1859#issuecomment-607377463, or unsubscribe https://github.com/notifications/unsubscribe-auth/AO45YZUSUVAU5KEQ4HO3SXLRKNY4NANCNFSM4LZCUZIQ .
Keen too. In also wanted to just pickup the latest state data for the US, but not sure how to make the most recent date a variable in the script.
zootpiel I use this to pull yesterday's data, currently though 3/31's numbers are not adding up correctly: = Csv.Document(Web.Contents("https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_daily_reports/" & Date.ToText(Date.AddDays(DateTime.Date(DateTime.LocalNow()),-1), "MM-dd-yyyy") & ".csv"),[Delimiter=",", Encoding=65001])
Djtrip83 would love to see your script
I have created a simple Dashboard for the USA and my little State of Alaska. The primary data source is this Repo plus the USAFacts and some local data to view the test results.
Power BI Report in PBX in the zip file. If you use it, please share any changes or enhancements with me so we can all benefit.
JHU_COVID_Sample.zip
I wanted to learn how to contribute in GitHub (always taking and never giving) so I managed to submit my first pull request to original repository. If you look at it, I pasted the Power M Query code as wellas a suggestion where different scripts could be added.
zootpiel I use this to pull yesterday's data, currently though 3/31's numbers are not adding up correctly: = Csv.Document(Web.Contents("https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_daily_reports/" & Date.ToText(Date.AddDays(DateTime.Date(DateTime.LocalNow()),-1), "MM-dd-yyyy") & ".csv"),[Delimiter=",", Encoding=65001])
Probably down to the fact data structure changes. Columns were swapped/renamed at some point in March and it affected the Confirmed, Deaths and Recovered columns
I created a Power BI script to pull all Daily Report CSVs at once in a loop. Not sure if this is the right place to share but if interested let me know.