SOLVED

Excel Web Query Not Updating Daily Data

Copper Contributor

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! 

5 Replies
How did you get the data in, using the old webquery or the PowerQuery one?

@Jan Karel Pieterse using PowerQuery :) 

best response confirmed by danielleach (Copper Contributor)
Solution

@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...

 

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 :) 

1 best response

Accepted Solutions
best response confirmed by danielleach (Copper Contributor)
Solution

@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...

 

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

View solution in original post