Forum Discussion
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
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,
2 Replies
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,