Forum Discussion

kemosully's avatar
kemosully
Frequent Visitor
3 years ago

Get Dataflow Transactions REST API retrieves 10 transactions the first time, but only the 11th after

I'm building out a bash script using the Power BI REST API to check when a dataflow completes its refresh. I need to bash rather than powershell due to the manner in which we will deploy the solution...
Dataflow
Need Help
ibarrau's avatar
ibarrau
Super User
3 years ago

Hi! it looks like an API limitation. It doesn't have pagination but it limits the response to 10 transactions. I'll leave feedback at the docs specifing that it doesn't say anything about limiting the response 😞

I hope that change in a near future, but for now, it looks like you won't be able to get more transactions.

I hope that make sense.

  • kemosully's avatar
    kemosully
    Frequent Visitor
    3 years ago

    I was aware that it would limit the responses, but I think I was more confused about why it would not return all 10 most recent transactions each time it was called in bash.

     

    I've changed tactics to work on this in python because it gets all 10 most recent transactions each time I call the api.

  • amitra's avatar
    amitra
    New Member
    3 years ago

    I need your help as you are working on this. How you are generating the token. I am using a service principle but it gives me 401 error when trying to all this API. 

     

  • ahwanmishra's avatar
    ahwanmishra
    Regular Visitor
    2 years ago

    Hii Any idea, if this limitation has been resolved?
    I have recently been encountering this same error wherein the latest refresh isnt being being pulled in the top 10 transactions.

    • MorelG's avatar
      MorelG
      Advocate I
      1 year ago

      Hello, 
      today I tried to add top parameter to an api call request: 

      groups/{GroupId}/dataflows/{DataflowId}/transactions?$top=100

       Then the api call returns more than 10 transactions. Unfortunately this option is not described in Microsoft documentation.

      • rjhale's avatar
        rjhale
        Helper V
        1 year ago

        The $top parameter doesn't seem to work for me.  I get an error stating "No HTTP resource was found that matches the request url".  This is really frustrating as the call seems to return an almost random set of Dataflow transactions which makes it hard to validate that our Dataflows are working as expected.

         

        Any other thoughts on how to ensure we get the latest 10 or even the full set of transactions?