Mar 09 2020 12:42 AM
I am using this URL as a web query in excel: https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_ti...
The content of the site gets updated daily (the content changes but the URL itself remains the same).
When I click 'Refresh Data' in excel, the latest dates do not seem to update, and I can only get data from the date that I initially entered the web query.
Am I missing something? And if possible I would like to be able to click refresh and the latest date to get added onto the data table.
Thanks!
Mar 09 2020 05:58 AM
Mar 09 2020 03:26 PM
@Jan Karel Pieterse using PowerQuery :)
Apr 12 2020 07:38 AM
Solution@danielleach, if you are still having the issue, I found the solution here:
Quite easy, you need to edit the import settings in the advanced editor and remove the reference to the number of columns.
Hope it helps
Apr 12 2020 06:44 PM
@marvalar, thank you so much, this worked perfectly! Really appreciated :)
Apr 12 2020 07:38 AM
Solution@danielleach, if you are still having the issue, I found the solution here:
Quite easy, you need to edit the import settings in the advanced editor and remove the reference to the number of columns.
Hope it helps