Forum Discussion

zia_ward's avatar
zia_ward
Frequent Visitor
5 years ago
Solved

Web data won't refresh in Power BI Desktop report

Hi,   In my Desktop Power BI Report, I make use of Web data (via import). When I click on Refresh, the process completes successfully but I don't see the Web-based dataset to be updated. The web da...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    When you import a CSV file the connector makes a note of the number of columns.

     

     

    let
    Source = Csv.Document(Web.Contents("https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_US.csv"),[Delimiter=",", Columns=608, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
    #"Promoted Headers"

     

     

    You need to manually edit that part of the code and remove the reference.  Otherwise the connector will ignore any new columns that are added.

     

     

    let
    Source = Csv.Document(Web.Contents("https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_US.csv"),[Delimiter=",",  Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
    #"Promoted Headers"

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

When you import a CSV file the connector makes a note of the number of columns.

 

 

let
    Source = Csv.Document(Web.Contents("https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_US.csv"),[Delimiter=",", Columns=608, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
    #"Promoted Headers"

 

 

You need to manually edit that part of the code and remove the reference.  Otherwise the connector will ignore any new columns that are added.

 

 

let
    Source = Csv.Document(Web.Contents("https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_US.csv"),[Delimiter=",",  Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
    #"Promoted Headers"