Forum Discussion

Lixarius's avatar
Lixarius
New Member
3 years ago

Dynamic Date within source for Power BI Report Server automated refresh

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