Forum Discussion
Solved
PowerBI API - Execute Queries on Dataset - Problem with DAX Statement
Good morning, i am not able to execute any queries via the Execute query REST API, except when i ONLY use evaluate. As you can see this one works without problem: { "queries": [ { "query": "E...
Hi RubenSchilling ,
As far as I know, AVERAGE() should be an aggregation function which will return aggregated value instead of a table.
Datasets - Execute Queries Rest API will return data as a table.
So Power BI will return error.
You may refer to this offical blog to learn more details.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In the query text before any " will be used You need to add \. At list this worked for me in Azure Data Factory - spent some time on this also ...
"query": "HERE !!!! "