Power BI REST API Bad Request Object must implement IConvertible.

[soldous]

Hi all,

I would like to use a new PBI API to get activity events but when I try to call the API I receive 400 bad request: Object must implement IConvertible for startDateTime and endDateTime. 

I have registered app in Azure Active Directory with Power BI Service Tenant.ReadAll permission.

For getting access token I call POST on https://login.microsoftonline.com/common/oauth2/token with body:

grant_type=password
&username=user with global admin permission
&password=password
&client_id=client ip
&client_secret=client secret
&resource=https://analysis.windows.net/powerbi/api

I used the received token for Bearer authorization on https://api.powerbi.com/v1.0/myorg/admin/activityevents?startDateTime=2020-01-20T00:00:00.000Z&endDa... and receive the error above.

Other APIs works fine.

Could anyone help, please?

Thanks a lot.

Regards,

Zdenek 

[soldous · Accepted solution]

I talked with the support and the solution is to enclose dates in the single quotation marks.

Hope they changed it in the official documentation.

[bdarbonneau]

When you manage to retrieve the first page, and in order to fetch the next page, you will need to pass the continutation token retrieved from the inital response.

Be aware that for this parameter, you also need to 'Uridecode' the token returned by the API and enclose it in single quotes.