Data refresh from web source requires Personal Gateway?

Hi helenah,

I have tested it on my side using the last URL provided above as web source to create a report, then published it to the service, and I can do a schedule refresh and manual refresh on that dataset without any issue.

URL I used for test: http://sdw.ecb.europa.eu/export.do?dc=&removeItem=&rc=&ec=&legendPub=published&node=9691297&oc=&df=true&FREQ=M&pb=&legendNor=&SERIES_KEY=120.EXR.M.USD.EUR.SP00.A&SERIES_KEY=120.EXR.M.GBP.EUR.SP00.A&SERIES_KEY=120.EXR.M.DKK.EUR.SP00.A&SERIES_KEY=120.EXR.M.PLN.EUR.SP00.A&SERIES_KEY=120.EXR.M.SEK.EUR.SP00.A&SERIES_KEY=120.EXR.M.NOK.EUR.SP00.A&SERIES_KEY=120.EXR.M.RUB.EUR.SP00.A&legendRef=reference&DATASET=0&exportType=xls

Following is query I used in Advanced Editor.

let
    Source = Csv.Document(Web.Contents("http://sdw.ecb.europa.eu/export.do?dc=&removeItem=&rc=&ec=&legendPub=published&node=9691297&oc=&df=true&FREQ=M&pb=&legendNor=&SERIES_KEY=120.EXR.M.USD.EUR.SP00.A&SERIES_KEY=120.EXR.M.GBP.EUR.SP00.A&SERIES_KEY=120.EXR.M.DKK.EUR.SP00.A&SERIES_KEY=120.EXR.M.PLN.EUR.SP00.A&SERIES_KEY=120.EXR.M.SEK.EUR.SP00.A&SERIES_KEY=120.EXR.M.NOK.EUR.SP00.A&SERIES_KEY=120.EXR.M.RUB.EUR.SP00.A&legendRef=reference&DATASET=0&exportType=xls"),[Delimiter=",", Columns=8, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}}),
    #"Removed Top Rows" = Table.Skip(#"Changed Type",4),
    #"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows")
in
    #"Promoted Headers"

Have you received any error when you tried to do the refresh on the service? Could you try deleting the whole dataset and republish it to the service to see if the issue remains?:smileyhappy:

In addition, please go to check if the data souce credentials are still valid for that dataset.

Regards