topic Extracting dataset queries with powerBI REST in Developer

Extracting dataset queries with powerBI REST

sonsi — Tue, 12 Sep 2023 06:52:03 GMT

Hi,

I am working on a c# project which I want to contact the Power BI Rest v1.0 in order to extract the datasets my team has.

I am looking for a way to get all the datasets' queries.

I'd like to find a way, with a given datasetID, the get the queries it's holding through the API. I saw someone suggesting to use @https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/executeQueries and run

select * from $SYSTEM.TMSCHEMA_PARTITIONS against the dataset but when I am trying this I get:

{
  "results": [
    {
      "error": {
        "code": "DataExtensionError",
        "message": "",
        "details": [
          {
            "code": "AnalysisServicesErrorCode",
            "detail": {
              "type": "1",
              "value": 0
            }
          }
        ]
      }
    }
  ]
}

I'd appriciate some help

Thanks

Re: Extracting dataset queries with powerBI REST

Anonymous — Thu, 14 Sep 2023 02:29:17 GMT

Hi @sonsi,

AS the official document and correspond limitations list mentions, current this API only support DAX expressions. The query that you used is T-SQL queries which not supported.

Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Regards,
Xiaoxin Sheng

Re: Extracting dataset queries with powerBI REST

sonsi — Mon, 02 Oct 2023 08:34:15 GMT

Is there another way to get the queries through an API the queries of a specific dataset?