Datamart : Using queries

[Vitalth]

Hi,

I tried to use Queries in datamart in order to use it on Web API executeQueries.
If I create a query in my Datamart, this one has a name. (I don't how to change the name but it is another problem).

In POST API I try (in my payload) :

{

  "queries": [

    {

      "query": "EVALUATE VALUES('{My Query Name}')"

    }

  ]

}

But the answer is :

{

    "error": {

        ...,

                        "value": "Query (1, 17) Cannot find table 'SQL query 1'."

       ...

}

Do you know if is it possible to use Queries in the Web API and if yes how to use it.

Thanks for your support.

[Vitalth]

Thanks for your answer and support

I already saw the last link you gave me and that's why I wrote my post. I found that very interesting and I wanted to see if we can combine features described in second links with theses in the third links. I didn't know the second links you give me. (I saw the possibility to create some query in datamart but I try myself without documentation). So the second link was very helpfull for me for other questions. Thanks.
But I still don't know how to combine creation of query in datamart and execute them in REST API ExecuteQuery

[v-zhangti]

Hi, @Vitalth 

Please refer to the following links in the hopes of helping you.

Solved: Datamart SQL Queries - Microsoft Power BI Community

Announcing improvements to Datamart Query editor | Microsoft Power BI Blog | Microsoft Power BI

Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

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