REST API - Executequeries function

[Abhinay_Rozer]

REST API - Executequeries function

Hi All,

I am trying to execute the "ExecuteQueries" REST API method on a dataset using Python programming, but I am not sure where i need to write body.
I gone through the microsoft documentation for ExecuteQueries REST API method
there it's mentioned to provide body in json format to get desired results
but i don't have any clue how i can pass this body to the executequeries API

Can you plese help on this if possible 
thanks in advance

[ibarrau · Accepted solution]

Hi Abhinary_Roze. Yes the doc specify a body for the post. You can build a dict at python and then convert it as the parameter of the request. Check this example using requests and json libraries:

import requests
import json
url= "https://api.powerbi.com/v1.0/myorg/groups/{}/datasets/{}/executeQueries".format(workspace_id, dataset_id)
body = {
    "queries": [{"query": query}], 
    "serializerSettings": {"includeNulls": "true"}
}
res = requests.post(url, data = json.dumps(body), headers = headers) 

The requests.post will receive the url, body and headers (here you must write the bearer). You can convert your python dictionary (body variable) with json.dumps.

If you feel this all is too much you can use a Power Bi Rest API python library like SimplePBI. In there you can just import library, create token, create dataset class and make the request.

https://pypi.org/project/SimplePBI/

I hope that helps,

[Abhinay_Rozer]

@ibarrau