Refresh issue on portal

Hi, Mekist 

If possible, avoid using dynamic URL and instead use fixed URL to fetch data.

Alternatively, you can extract the dynamic part as parameters and then use these parameters in Power Query to construct the URL. you can refer to the following M code:

let
    produceName = "XXX", // Replace this with the actual produceName parameter
    url = "https://www.isyatirim.com.tr/_layouts/15/IsYatirim.Website/Common/Data.aspx/MaliTablo?companyCode=" & produceName & "&exchange=TRY&financialGroup=XI_29&year1=2024&period1=12&year2=2024&period2=9&year3=2024&period3=6&year4=2024&period4=3",
    Kaynak = Json.Document(Web.Contents(url)),
    value = Kaynak[value],
    TabloyaDönüştürüldü = Table.FromList(value, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    GenişletilenColumn1 = Table.ExpandRecordColumn(TabloyaDönüştürüldü, "Column1", {"itemCode", "itemDescTr", "itemDescEng", "value1", "value2", "value3", "value4"}, {"Column1.itemCode", "Column1.itemDescTr", "Column1.itemDescEng", "Column1.value1", "Column1.value2", "Column1.value3", "Column1.value4"})
in
    GenişletilenColumn1

It is also possible to manually refresh the dataset in Power BI Desktop and then publish it to the Power BI service.

You can also change the data source to a local data source and then configure the Data Gateway to allow Power BI Service to access the local data source.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.