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
Solved! Go to 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.
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.
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
User | Count |
---|---|
9 | |
5 | |
3 | |
2 | |
2 |