Forum Discussion

danielleach's avatar
danielleach
Copper Contributor
Mar 09, 2020
Solved

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...
Charting
excel
Formulas and Functions
power bi
  • marvalar's avatar
    marvalar
    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

marvalar's avatar
marvalar
Copper Contributor
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's avatar
    danielleach
    Copper Contributor
    Apr 13, 2020

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

Resources