As of right now, the main data set that people are using is from Johns Hopkins University Center for Systems Science and Engineering (JHU CSSE). The data set can be find on GitHub here: https://github.com/CSSEGISandData/COVID-19
To connect the data to Power Bi, find the page where you can access the .CSV file you need. In this case, we will navigate to the page that has the time series. If there are multiple .CSV files as there are in this case, then we will need to perform the steps per .CSV file and build relationships in the Power BI data model.
Step 1: Navigate to the .CSV file by choosing the file and click the "Raw" button
Step 2: Save the link of the raw .CSV file and open up Power BI Desktop. In Power BI Desktop, click "Get Data" and choose "Web". Paste the link for the .csv file and click "Connect". Please note that you might need to sign up for a GitHub account
Step 3: Transform the data and build a report to your liking!
Comments