Forum Discussion
REST API - Executequeries function
- 3 years ago
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,
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,