0

I created a datasource behind gateway for using rest API. Datasource got created. However, now I want to add a table(create a dataset) from the created datasource to use it in a report. However, I am getting the below error from API.

{
    "error": {
        "code": "FailedToDeserializeDatasetError",
        "pbi.error": {
            "code": "FailedToDeserializeDatasetError",
            "parameters": {},
            "details": [],
            "exceptionCulprit": 1
        }
    }
}

API request body:

{
    "datasources": [
        {
            "gatewayId":"gateway_id",
            "datasourceId": "datasource_id",
            "datasourceType": "PostgreSql",
            "connectionDetails": "{\"server\":\"server_address\",\"database\":\"database_name\"}",
            "credentialType": "Basic",
            "credentialDetails": {
                "privacyLevel": "None",
                "useEndUserOAuth2Credentials": false
            }
        }
    ],
    "defaultMode": "Push",
    "name": "API DS 1",
    "tables": [
        {
            "name":"currency_rates",
            "description": "DS Table 1 Demo API",
            "columns":[
                {
                    "name":"id",
                    "dataType":"Int64"
                },
                {
                    "name":"traded_on",
                    "dataType":"DateTime"
                },
                {
                    "name":"currency_code",
                    "dataType": "string"
                },
                {
                    "name":"close",
                    "dataType": "Double"
                }
            ]
        }
    ]
}

Not sure what is wrong here.

API Reference: https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-post-dataset-in-group

Aman Khandelwal
  • 148
  • 1
  • 13

0 Answers0