topic Re: REST API - Executequeries function in Developer

REST API - Executequeries function

Anonymous — Sat, 20 Aug 2022 06:34:51 GMT

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

Re: REST API - Executequeries function

Anonymous — Sat, 20 Aug 2022 06:35:30 GMT

@ibarrau

Re: REST API - Executequeries function

ibarrau — Mon, 22 Aug 2022 11:51:40 GMT

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,