topic Re: REST API Dataset Queries in Developer

REST API Dataset Queries

barakb32 — Sat, 27 Nov 2021 11:46:30 GMT

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

Re: REST API Dataset Queries

lbendlin — Sat, 27 Nov 2021 19:10:16 GMT

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.

Re: REST API Dataset Queries

Anonymous — Fri, 19 Aug 2022 08:23:52 GMT

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)

Re: REST API Dataset Queries

lbendlin — Fri, 19 Aug 2022 16:19:58 GMT

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.

Re: REST API Dataset Queries

Anonymous — Fri, 19 Aug 2022 16:24:23 GMT

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

Re: REST API Dataset Queries

lbendlin — Fri, 19 Aug 2022 17:11:25 GMT

the body goes into the Content attribute. See example 2

Web.Contents - PowerQuery M | Microsoft Docs