REST API Dataset Queries

[barakb32]

Hello,

I would like to check if a certain filter is applied on every Power Query query that is used to build and refresh the datast.

Is there a way to programatically see thw query code for every query?

Thanks

[lbendlin · Accepted solution]

Run a DMV query against the dataset. 

 select * from $SYSTEM.TMSCHEMA_PARTITIONS

You can use DAX Studio or any other tool that can access the XMLA endpoint.

[Abhinay_Rozer]

Hi @lbendlin 
I am trying to write python code for executequeries REST API 
I am able to other REST API queries without any problem.

but Executequeries 
--https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/executeQueries

i don't have any clue where i can write the DAX query...and how can i write it.
I gone through the documentation https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries

but still not getting where i need to write the query and how to pass it 
https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/executeQueries 
here

if possible can you please let me know how can execute this in python. (any dax query is fine)

[lbendlin]

No idea why you would want to do this in Python.  But if you insist then you need to construct the body according to this example 

Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Docs

including all the character escapes etc.  It must be in this format , otherwise it will not work.

[Abhinay_Rozer]

Thanks for replay @lbendlin 
yes i got it even in Powershell/ Python 
i just want to know once i build the body where in this line i need to pass https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/executeQueries  the body??

I appreciate if you give any suggestions on this 
thanks in advance

[lbendlin]

the body goes into the Content attribute. See example 2

Web.Contents - PowerQuery M | Microsoft Docs