topic Create Dataset from a Postgresql datasource using REST API in Developer

Create Dataset from a Postgresql datasource using REST API

amankhandelwal — Wed, 15 Feb 2023 10:03:37 GMT

Hello,

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 } } }

My 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

Re: Create Dataset from a Postgresql datasource using REST API

jaweher899 — Wed, 15 Feb 2023 17:28:25 GMT

The error message "FailedToDeserializeDatasetError" usually indicates that the JSON payload sent to the API is not in the expected format. It's possible that there is a syntax error or some missing information in your request.

Here are a few things you can check:

Make sure the "datasourceId" in your request matches the ID of the datasource you created earlier.
Verify that the gateway ID is correct and that the gateway is online and available.
Double-check the JSON payload and make sure that all the required fields are included. You can use a JSON validator to check the syntax.
Check the Power BI service logs for any additional error messages that may provide more details on the issue.

Re: Create Dataset from a Postgresql datasource using REST API

amankhandelwal — Thu, 16 Feb 2023 08:14:04 GMT

@jaweher899 by PowerBI service logs you meant the one mentioned in this documentation link: https://learn.microsoft.com/en-us/power-bi/admin/service-admin-auditing

Or something else?