How to get total rows count from the powerbi dataset tables using ExecuteQueries API?

Stephen Sebastian (Thinq24) 0 Reputation points
2023-11-07T12:39:21.5366667+00:00

I don't know. which is the exact query to get the table total rows count. i get the following error

{
  "error": {
    "code": "DatasetExecuteQueriesError",
    "pbi.error": {
      "code": "DatasetExecuteQueriesError",
      "parameters": {},
      "details": [
        {
          "code": "DetailsMessage",
          "detail": {
            "type": 1,
            "value": "Query (1, 1) The syntax for 'COUNTROWS' is incorrect. (COUNTROWS (Credits))."
          }
        },
        {
          "code": "AnalysisServicesErrorCode",
          "detail": {
            "type": 1,
            "value": "3238920194"
          }
        }
      ]
    }
  }
}
Microsoft Partner Center API
Microsoft Partner Center API
Microsoft Partner Center: A Microsoft website for partners that provides access to product support, a partner community, and other partner services.API: A software intermediary that allows two applications to interact with each other.
337 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.