SOLVED

Excel Web Query Not Updating Daily Data

%3CLINGO-SUB%20id%3D%22lingo-sub-1217134%22%20slang%3D%22en-US%22%3EExcel%20Web%20Query%20Not%20Updating%20Daily%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1217134%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20this%20URL%20as%20a%20web%20query%20in%20excel%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fraw.githubusercontent.com%2FCSSEGISandData%2FCOVID-19%2Fmaster%2Fcsse_covid_19_data%2Fcsse_covid_19_time_series%2Ftime_series_19-covid-Confirmed.csv%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fraw.githubusercontent.com%2FCSSEGISandData%2FCOVID-19%2Fmaster%2Fcsse_covid_19_data%2Fcsse_covid_19_time_series%2Ftime_series_19-covid-Confirmed.csv%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20content%20of%20the%20site%20gets%20updated%20daily%20(the%20content%20changes%20but%20the%20URL%20itself%20remains%20the%20same).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20click%20'Refresh%20Data'%20in%20excel%2C%20the%20latest%20dates%20do%20not%20seem%20to%20update%2C%20and%20I%20can%20only%20get%20data%20from%20the%20date%20that%20I%20initially%20entered%20the%20web%20query.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAm%20I%20missing%20something%3F%20And%20if%20possible%20I%20would%20like%20to%20be%20able%20to%20click%20refresh%20and%20the%20latest%20date%20to%20get%20added%20onto%20the%20data%20table.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1217134%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1217544%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Web%20Query%20Not%20Updating%20Daily%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1217544%22%20slang%3D%22en-US%22%3EHow%20did%20you%20get%20the%20data%20in%2C%20using%20the%20old%20webquery%20or%20the%20PowerQuery%20one%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1218763%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Web%20Query%20Not%20Updating%20Daily%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1218763%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3Busing%20PowerQuery%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1219366%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Web%20Query%20Not%20Updating%20Daily%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1219366%22%20slang%3D%22en-US%22%3ESee%3A%20%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdatachant.com%2F2016%2F12%2F20%2Fhow-to-enforce-power-querypower-bi-to-import-uncached-data-from-the-web%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdatachant.com%2F2016%2F12%2F20%2Fhow-to-enforce-power-querypower-bi-to-import-uncached-data-from-the-web%2F%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1301088%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Web%20Query%20Not%20Updating%20Daily%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1301088%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F577266%22%20target%3D%22_blank%22%3E%40danielleach%3C%2FA%3E%2C%26nbsp%3Bif%20you%20are%20still%20having%20the%20issue%2C%20I%20found%20the%20solution%20here%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.powerbi.com%2Ft5%2FDesktop%2FNew-column-in-source-table-not-appearing-in-dataset-after%2Fm-p%2F391320%2Fhighlight%2Ftrue%23M178373%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcommunity.powerbi.com%2Ft5%2FDesktop%2FNew-column-in-source-table-not-appearing-in-dataset-after%2Fm-p%2F391320%2Fhighlight%2Ftrue%23M178373%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuite%20easy%2C%20you%20need%20to%20edit%20the%20import%20settings%20in%20the%20advanced%20editor%20and%20remove%20the%20reference%20to%20the%20number%20of%20columns.%3C%2FP%3E%3CP%3EHope%20it%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1301725%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Web%20Query%20Not%20Updating%20Daily%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1301725%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F395806%22%20target%3D%22_blank%22%3E%40marvalar%3C%2FA%3E%2C%20thank%20you%20so%20much%2C%20this%20worked%20perfectly!%20Really%20appreciated%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted
How did you get the data in, using the old webquery or the PowerQuery one?
Highlighted

@Jan Karel Pieterse using PowerQuery  

Highlighted
Best Response confirmed by danielleach (New 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

Highlighted

@marvalar, thank you so much, this worked perfectly! Really appreciated