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\\Basecamp 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.

Note: Since this connector supports multiple schemas, custom schema files for Basecamp should be structured such that:

• Each schema should have its own folder, named for that schema.
• All schema folders should be contained in a parent folder.

Location should always be set to the parent folder, and not to an individual schema's folder.

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