Power Query refreshing too slow

[gargamalebarbosa]

Hi,
When refresh the query, i takes too much time. But if i cancel it than start again refreshing time is normal.
What is my mistake ?

Thank you,

let
    Kaynak = Json.Document(Web.Contents("https://www.bp.com/bp-tr-pump-prices/api/PumpPrices?strCity=ANTALYA", [Headers=[#"User-Agent"="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36"]])),
    #"Tabloya Dönüştürüldü" = Table.FromList(Kaynak, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Genişletilen Column1" = Table.ExpandRecordColumn(#"Tabloya Dönüştürüldü", "Column1", {"DtPriceListDate", "District", "City", "Benzin", "GazYagi", "BenzinUltimate", "MotorinUltimate", "Motorin", "FuelOil", "KaloriferYakiti", "FuelOilYuksekKukurt", "LpgPrice"}, {"DtPriceListDate", "District", "City", "Benzin", "GazYagi", "BenzinUltimate", "MotorinUltimate", "Motorin", "FuelOil", "KaloriferYakiti", "FuelOilYuksekKukurt", "LpgPrice"})
in
    #"Genişletilen Column1"

 

[alansidman]

It may have to do with your internet speeds and the size of the file you are importing. Have you tried on a computer that is linked to a different Internet connection that has a faster download speed?

 

[gargamalebarbosa]

I tried with differents computers and connections. Same problem.