Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
zeskysee
New Member

PowerBI Rest - Sample Request to create MySQL dataset

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: []
        }
    }
]

 

1 REPLY 1
v-micsh-msft
Employee
Employee

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.