Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI Rest API continuation token is corrupted

Hi, When running the Get Activity Events API Call, it returns a few activities and a continuation token. When trying to use the token to contionue the call, i get the following error:    {   "...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous 

    Yes, yous should not use the continuationToken, but the continuationUri, and use it to make a new get request. 

    The documentation for this API is poor and outdated, unfortunately.

    Let me know if you need further assistance.

maril's avatar
maril
New Member
5 years ago

Hi,

I got the same error when building PowerAutomate Flow to retreive PBI activity events using custom connector based on Swagger https://github.com/microsoft/powerbi-rest-api-specs/blob/master/swagger.json . 

Turned out that the continuation token needs to be decoded for the 'Returns a list of audit activity events for a tenant' step to work properly.

In MS Flow - Parse the continuation token from Json, then decode with function decodeUriComponent() and finally wrap the expression in single quotes. 

eg. 'decodeUriComponent(body('Parse_JSON')?['continuationToken'])'

 

PowerShell does it behind the scene like this:

https://github.com/microsoft/powerbi-powershell/blob/master/src/Modules/Admin/Commands.Admin/GetPowerBIActivityEvent.cs

...

 string formattedContinuationToken = $"'{WebUtility.UrlDecode(response.ContinuationToken)}'";
response = client.Admin.GetPowerBIActivityEvents(null, null, formattedContinuationToken, null);

...