dynamic base url with web.contents and scheduled refresh in power bi service

[BrianIsTaken]

Hi,

i would like to use the function web.contents to retrieve data from a datasource, but with a dynamic base url. for example web.contents(dynamic.example.com) and then a static path, but when doing so Power bi service gives a error, because the url is dynamic which it cant handle. and in Power BI i see the following error:

in other posts people used the "skip test connection" option, but that is not available in Power BI service in this case. Does anyone else have a idea/solution for this problem?

[lbendlin · Accepted solution]

"dynamic base url"  is a no-no.  Use RelativePath and Query instead, or you can try masking your dynamic URL behind a redirect.

Web.Contents - PowerQuery M | Microsoft Learn

[Mekist]

I have the same problem, I did not use Relati and Path and Query, can you help?

(produceName as text) as table =>
let
    Kaynak = Json.Document(Web.Contents("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")),
    value = Kaynak[value],
    #"Tabloya Dönüştürüldü" = Table.FromList(value, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Genişletilen Column1" = Table.ExpandRecordColumn(#"Tabloya Dö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şletilen Column1"

[lbendlin]

Merhaba, Lutfen follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1

[Mekist]

I could not solve the queries you specified.

[BrianIsTaken]

alright thats to bad, Thank you for your response