Dynamic Date within source for Power BI Report Server automated refresh

[Lixarius]

Hello,

I am currently facing an issues where we can pull from API only last 4 months of data based on current month.

There is no possibility to change it within application, so I have to work somehow with dynamic dates for automated daily refresh.

However the main issue is the error:

[0] -1056505856: This report contains dynamic datasources, which cannot be refreshed in Power BI Report Server.

I've tried using a solution provided within topic below, but I've noticed that once Current Value for parameter is set, it doesn't change along with date (or it's just me doing something wrong):
https://community.powerbi.com/t5/Desktop/Daily-data-refresh-from-the-same-file/m-p/1610734

Here is my current query, that works for manually within Power BI Desktop but not for Report Server automated refresh (error is not showing up anymore, but date within parameter is not being refreshed):

let
Source = Json.Document(Web.Contents("...URL..." & #"Parameter1"))
in
Source

My parameter is based on list as per mentioned previously solution from other thread:

And this is my parameter:

Can anybody provide me with solution or advise over this problem?

Any support will be highyl appreciated.

Kind regards

[Daryl-Lynch-Bzy]

Hi @Lixarius  - you need to use the Relative Path or Query feature of Web.Contents to run the queries in the Web Service.  Please watch this video by Chris Webb/RADCAD - around 26-27 minute he explains the issue and resolve it.

Accessing API and web service data using Power Query - by Chris Webb - YouTube