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
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.