cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
barakb32
Advocate I
Advocate I

REST API Dataset Queries

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

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

lbendlin_0-1638040206868.png

 

View solution in original post

5 REPLIES 5
lbendlin
Super User
Super User

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.

lbendlin_0-1638040206868.png

 

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)

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.

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

the body goes into the Content attribute. See example 2

 

Web.Contents - PowerQuery M | Microsoft Docs

 

 

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.