Forum Discussion
Excel Web Query Not Updating Daily Data
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_time_series/time_series_19-covid-Confirmed.csv
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!
danielleach, if you are still having the issue, I found the solution here:
https://community.powerbi.com/t5/Desktop/New-column-in-source-table-not-appearing-in-dataset-after/m-p/391320/highlight/true#M178373
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
5 Replies
danielleach, if you are still having the issue, I found the solution here:
https://community.powerbi.com/t5/Desktop/New-column-in-source-table-not-appearing-in-dataset-after/m-p/391320/highlight/true#M178373
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
marvalar, thank you so much, this worked perfectly! Really appreciated 🙂
- How did you get the data in, using the old webquery or the PowerQuery one?
