trying to get ActivityEvents from PowerBI admin for more than one day using TimeXtender REST API

Hi,

i want to retrieve ActivityEvents from PowerBI Admin using then TimeXtender REST API.

configure the base URL as: https://api.powerbi.com/v1.0/myorg/admin/
Endpoint configured as: activityevents?StartDateTime=%27{BDAT}%27&EndDateTime=%27{EDAT}%27&filter=Activity%20eq%20%27ViewReport%27

{BDAT} and {EDAT} are populated using a SQL Query:
 

DECLARE @i int = 0

WHILE @i > -5
BEGIN
    select CONCAT(FORMAT(dateadd(day,@i,GETDATE()), 'yyyy-MM-dd'),'T00%3A05%3A00.000') as [BDAT],
    CONCAT(FORMAT(dateadd(day,@i,GETDATE()), 'yyyy-MM-dd'),'T23%3A55%3A00.000') as [EDAT]
    SET @i = @i - 1
END

i hoped it will loop for the past 5 days but unfortunately this doesn't work.

Setting the BDAT 5 days in the past doesn't work either. 

Any ideas how to solve this?

by the way we are using TX Classic V 20.10.66.64 and TimeXtender REST API v16.4.23.0 (also tested with 16.4.21.0)

Kind regards,

Hans