Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
we are trying to use the following
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries?source=docs
where you can use a REST API and add a query like this
{ "queries": [ { "query": "EVALUATE VALUES(MyTable[Column])" } ], "serializerSettings": { "includeNulls": true } }
I am a little confused though. Queries to me mean the tables in Power BI. So my question is. Can I use this to run DAX Measures? To me these a Measures created in DAX Rather than queries. It doesnt mention this in the documentation so I just wanted to get it straight in my head before we continue
Solved! Go to Solution.
Measures are calculations computed at the granularity specified in the DAX query they are a part of. They are defined at the model level but evaluated only at DAX execution time.
This API allows you to control what goes into your DAX query (which columns or measures). So if you have already defined a measure in your model (through PowerBI Desktop) and it is saved and published, then you can invoke it in your DAX query as follows:
EVALUATE ROW("MyMeasure", TableName[MyMeasure]) - this will evaluate it with no granularity specified, so effectively means for the whole dataset
or
EVALUATE(SUMMARIZECOLUMNS(TableName1[Column1], TableName2[Column2], "MyMeasure", TableName[MyMeasure]) - this will evaluat it at the granularity of Column1 and Column2 (for example for each Continent-Year combination)
A DAX query allows you to perform an evaluation of something from the data model. It's result is a table of data. What goes into the DAX query is up to the caller of the API. You can refer to public DAX documentation on what functions are available.
Measures are calculations computed at the granularity specified in the DAX query they are a part of. They are defined at the model level but evaluated only at DAX execution time.
This API allows you to control what goes into your DAX query (which columns or measures). So if you have already defined a measure in your model (through PowerBI Desktop) and it is saved and published, then you can invoke it in your DAX query as follows:
EVALUATE ROW("MyMeasure", TableName[MyMeasure]) - this will evaluate it with no granularity specified, so effectively means for the whole dataset
or
EVALUATE(SUMMARIZECOLUMNS(TableName1[Column1], TableName2[Column2], "MyMeasure", TableName[MyMeasure]) - this will evaluat it at the granularity of Column1 and Column2 (for example for each Continent-Year combination)
A DAX query allows you to perform an evaluation of something from the data model. It's result is a table of data. What goes into the DAX query is up to the caller of the API. You can refer to public DAX documentation on what functions are available.
Hi @DebbieE ,
Refer the the following link,and check if it could help you!
https://community.powerbi.com/t5/Developer/DAX-Measure-with-REST-API-dataset/m-p/445389
Best Regards
Lucien
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
21 | |
21 | |
17 | |
15 | |
11 |