Admin - Get Activity Events

[innocence84]

Hi,

We need to use pagination in the Admin - Get Activity Events  API. For the first call we need to pass startDateTime and endDateTime parameters. For the subsequent calls, we need to use continuationToken.

API run is successful by using recursive function in Power BI dataset. However, when we run the same recursive function in the Power BI dataflow, we are getting dependency cycle was detected error message. I tried to implement it with a do while loop and if statement. However I can not find do  while and while keyword in Power Query. I think they are not supported.

I found API pagination example by using List.Generate https://youtu.be/05yhwnuCjRw?t=432
However in the example, page is increasing incrementally. However I need to pass the API call result (continuationToken) to the subsequent API call. How can I implement this in Power BI data flow?

Thanks

[v-shex-msft]

HI @innocence84,

Perhaps you can try to with a custom function with recursion logic(invoke the function itself in the function internal) to invoke rest API and extract the previous result as parameter in following calculations.

Recursive Functions in Power BI / Power Query — The Power User

Regards,

Xiaoxin Sheng

[innocence84]

I applied the same logic. I received the code from https://bielite.com/blog/building-a-power-bi-admin-report/ 
Activity Query in the blog post was working in the dataset.

I used the same Activity Query, from the blog post, in a Power BI Dataflows. When I click save button, Power BI is throwing error message and it can not save the dataflow.
I wonder whether Power BI Dataflows support recursive functions.
Thanks