Forum Discussion
danielleach
Mar 09, 2020Copper Contributor
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 c...
- Apr 12, 2020
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
danielleach
Mar 09, 2020Copper Contributor
JKPieterse using PowerQuery 🙂
JKPieterse
Mar 10, 2020Silver Contributor