I’m creating a usage report of our workspaces using the power bi rest api connector (token less) and I’m looking for a way to set a dynamic end date (today) in the “get user activity” function. So it’s not dependent on a manual input of end date.

Setting a daily refresh on this report in the power bi service so I’d like yo see the latest user activity for the day in the power bi service.

It would be great if i can get help setting a delta load so it keeps the history of the user activity and just loads current day.

If this can’t be achieved, I’d also like to know why.

Thank you in advance.

enter image description here

I tried to manually use something like this in the EndDate box, datetime(today) without any luck or further creativity