Forum Discussion
Anonymous
4 years agoNot applicable
REST API - Executequeries function
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...
- 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,
Anonymous
4 years agoNot applicable