Forum Discussion

Mekist's avatar
Mekist
Icon for Helper III rankHelper III
1 year ago

Dynamic URL Refresh

Hello I want to retrieve the data by changing the "produce Name" section using the dynamic url address. How can I For example; ADEL, ULKER   "https://www.isyatirim.com.tr/_layouts/15/IsYatirim.W...
Need Help
Mekist's avatar
Mekist
Icon for Helper III rankHelper III
1 year ago

I don't understand exactly how it is done, if you don't mind, is it possible for you to share your PBI transfer?

Omid_Motamedise's avatar
Omid_Motamedise
Icon for Super User rankSuper User
1 year ago

Just go to the power query Editer, and then Advance editor, and past the next code.

 

 

let
    Part1="https://www.isyatirim.com.tr/_layouts/15/IsYatirim.Website/Common/Data.aspx/MaliTablo?companyCode=",
    
    Part3="&exchange=TRY&financialGroup=XI_29&year1=2024&period1=12&year2=2024&period2=9&year3=2024&period3=6&year4=2024&period4=3",

    Products={"ADEL", "ULKER"},

    Combine=List.Transform(Products, each  Json.Document(Web.Contents(Part1&_&Part3)))
in
    Combine