Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

COVID-19 Report

HI,   I need to create a real time COVID-19 power BI report.    I couldn't find any API that gives me live data.   Can anyone help me out with the API or any other data sources?   Thank you. ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Mariusz amitchandak Greg_Deckler 

     

    Finally, I found a workaround to get live COVID data to Power BI Desktop and Service. 

     

    The problem with using web URL is that the dataset refresh doesn't work when we publish the report to services. However, refresh works in Power BI desktop. 

     

    In order to fix this, I populated the data in google spreadsheet using =IMPORTHTML("https://www.worldometers.info/coronavirus/","Table") and then used spreadsheet as a data source in Power BI.

     

    Now, I have no issues with data refresh in the service as well as desktop. 

     

    Thank you.