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.

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? 

      • MorelG's avatar
        MorelG
        Advocate I
        1 year ago

        Hello, 
        maybe one update. In case you are running an API call from Powershell, let's try this:

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

        Also do not forget to add ? character after transactions. Otherwise it is not recognized that you are using additional parameters.
        It has been working in our environment prety well, but I definitely agree that this limitation is frustrating while working with dataflow API.