Specifies the location of a directory containing schema files that define tables, views, and stored procedures. Depending on your service's requirements, this may be expressed as either an absolute path or a relative path.

Data Type

string

Default Value

"%APPDATA%\\CData\\MySQL Data Provider\\Schema"

Remarks

Note for Power BI Gateway users: Because the Gateway runs under a Windows service account when you run the connector through the PowerBI Gateway, you must set the Location property to an absolute path. The Location property is only needed if you want to either customize definitions (for example, change a column name, ignore a column, etc.) or extend the data model with new tables, views, or stored procedures.

If left unspecified, the default location is %APPDATA%\\CData\\MySQL Data Provider\\Schema, where %APPDATA% is set to the user's configuration directory: