PowerBI Rest - Sample Request to create MySQL dataset

[zeskysee]

Hi All,

May I know anyone have the sample request on create mysql dataset from PowerBI Rest?

I try the following request body:

{
    "name": "sample-data",
    "defaultMode": "AsOnPrem",
    "datasources": [
        "connectionString": "server=myserver-ip;port=3306;uid=root;password=password;database=my_db"
    }
}

However I keep on hitting:

{
    "error": {
        "code": "FailedToParseConnectionStringError",
        "pbi.error": {
            "code": "FailedToParseConnectionStringError",
            "parameters": {},
            "details: []
        }
    }
]

[v-micsh-msft]

Adding Staff @eligr to confirm whether MySQL is supported when create DataSet through the REST API.

Based on the documentation, currently REST API create DataSet could only work with data streaming and the Analysis Services.

Refer to the Body Schema part.

Doc reference:

Create DataSet

Thread reference:

Problems on creating a new dataset with Power BI's REST API

Regards,

Michael