Forum Discussion

RubenSchilling's avatar
RubenSchilling
New Member
3 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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 Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.