topic Power BI REST API Bad Request Object must implement IConvertible. in Developer

Power BI REST API Bad Request Object must implement IConvertible.

soldous — Mon, 20 Jan 2020 14:45:46 GMT

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&endDateTime=2020-01-20T23:59:59.999Z and receive the error above.

Other APIs works fine.

Could anyone help, please?

Thanks a lot.

Regards,

Zdenek

Re: Power BI REST API Bad Request Object must implement IConvertible.

soldous — Tue, 28 Jan 2020 07:58:47 GMT

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.

Re: Power BI REST API Bad Request Object must implement IConvertible.

bdarbonneau — Thu, 20 Feb 2020 16:57:53 GMT

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.