Internal redirect for dataflow transactions at api.powerbi.com breaks api call

Question

Internal redirect for dataflow transactions at api.powerbi.com breaks api call

Doug Shawhan 96

I'm attempting to discover when the refresh of a given dataflow has finished.

Using the instructions I keep getting a failure message (in the body of a 200, which is ... less than restful to my poor brain)

   2021-10-01 13:51:21,410 - RefreshDataflows - INFO - {'Message': "No HTTP resource was found that matches the request URI 'http://wabi-us-north-central-h-primary-redirect.analysis.windows.net/v1.0/myorg/groups/foo/dataflows/bar/transactions'."}  
   2021-10-01 13:51:21,411 - RefreshDataflows - INFO - https://api.powerbi.com/v1.0/myorg/groups/foo/dataflows/bar/transactions

I have replaced the groupId and dataflowId values with "foo" and "bar", I have recreated the url using the "Focus mode" feature on the documentation page and get the expected response.

The first line is the decoded body of the response object (note the altered url), the second is the url that was passed to requests.

The available tags don't seem to have any focus on Power BI or it's REST api, so I really hope someone is searching deeply. :/

Doug Shawhan 96 Reputation points

2021-10-01T19:08:35.083+00:00
Just to stave off any of the stock answers:

My user has full ownership of the dataflows in question

My user has admin rights in the group

My user has both Dataflow.ReadWrite.All and Dataflow.Read.All permissions

I have a 60 second buffer between queries (playing it extra safe)

The documentation does not list any values that must appear in the body for the transaction to work (If you have ever noticed that datasets does not enforce this requirement, while dataflows does, you'll understand why I include it here).

I reiterate that I have checked the "real" url emitted by my code against the "working" url in the "Focus mode" editor in the documentation.

Answer accepted by question author

0 additional answers

Your answer

Doug Shawhan 96 Reputation points

2021-10-01T19:08:35.083+00:00

Just to stave off any of the stock answers:

My user has full ownership of the dataflows in question

My user has admin rights in the group

My user has both Dataflow.ReadWrite.All and Dataflow.Read.All permissions

I have a 60 second buffer between queries (playing it extra safe)

The documentation does not list any values that must appear in the body for the transaction to work (If you have ever noticed that datasets does not enforce this requirement, while dataflows does, you'll understand why I include it here).

I reiterate that I have checked the "real" url emitted by my code against the "working" url in the "Focus mode" editor in the documentation.

Answer 1

Doug Shawhan 96

The error was "hasty coder", I POSTed the request instead of GETting it.

In my defense, it seems logical that a RESTful api should return a 405 when you send it the wrong method. So I declare from atop my high horse.

0 comments

Share via

Internal redirect for dataflow transactions at api.powerbi.com breaks api call

0 additional answers

Your answer