Dynamic Web.Contents Power BI Refresh Error using RelativePath

I used this following Web.Content code to get data. It works fine on desktop, but it will not allow me to update data in Service – I get the error message that dynamic data sources can’t be refreshed.

let

    Balance = (EndDate as text) =>

Let

Source = Json.Document(Web.Contents("https://tripletex.no/v2/balanceSheet?dateFrom=2019-01-31&dateTo="&EndDate&"&includeSubProjects=false&includeActiveAccountsWithoutMovements=false&from=0&count=1000",[Headers=[authorization="Basic XXXXXXXXXXXXXXXXXXXXXXXXXXXXX"]])),

values = Source[values],

I have tried to tweek it using RelativePath to the following:

let

    Balance = (EndDate as text) =>

Let

Source = Json.Document(Web.Contents(https://tripletex.no/,[RelativePath=”v2/balanceSheet?dateFrom=2019-01-31&dateTo="&EndDate&"&includeSubProjects=false&includeActiveAccountsWithoutMovements=false&from=0&count=1000",Headers=[authorization="Basic XXXXXXXXXXXXXXXXXXXXXXXXXXXXX"]])),

values = Source[values],

Again, works fine in desktop, but now I get a new error message in Service when I update the data saying:

"Processig error [Unable to combine data] Section1/XXX/Expanded ParameterXXX reference other queries or steps, so it may not directly access a data source. Please rebuild this data combination."

Can someone please help me so that I am able to update the dataset in services?

Much appreciated 😊