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
JKPieterse
Mar 09, 2020Silver Contributor
How did you get the data in, using the old webquery or the PowerQuery one?
- danielleachMar 09, 2020Copper Contributor
JKPieterse using PowerQuery 🙂
- JKPieterseMar 10, 2020Silver Contributor