Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The MariaDB.Contents function returns a navigation table.
Summary
| Property | Value |
|---|---|
| Connector |  MariaDB |
| Products | Power BI (semantic models) Power Query Online |
| Release state | General availability |
| Category | Database |
| Authentication kinds | Basic |
| Data source kind | MariaDB |
| Function Reference Documentation | MariaDB.Contents |
| Support link | Contact the connector owner. |
Supported capabilities
Entry point: MariaDB.Contents
- DirectQuery
Parameters
Entry point: MariaDB.Contents
Required parameter count: 1
Returns a navigation table.
- Without a
databasename, returns a table of databases on the specified MariaDB serverservername. - With a
databasename, returns or a table of tables and views from the specified MariaDB databasedatabasenameon the serverservername.
databasename can be provided in either of the input parameters:
- In the MariaDB Data Source string after a semicolon. This approach allows using database-specific credentials. See details below.
- As the optional Database parameter. This approach allows using same credentials for all databases on the specified server
servername.
The MariaDB Data Source string uniquely identifies a data source in Power BI and allows using different credentials for each data source. Credentials for a data source are configured in Power BI Data source settings screen. MariaDB Power BI connector supports Basic authentication per server or per database. E.g. it is possible to connect with different credentials to databases residing on the same MariaDB server.
CreateNavigationProperties is a parameter for Odbc.DataSource.
A logical value that sets whether to generate navigation properties on the returned tables. Navigation properties are based on foreign key relationships reported by the driver. These properties show up as “virtual” columns that can be expanded in the query editor, creating the appropriate join.
If calculating foreign key dependencies is an expensive operation for your driver, you may want to set this value to false.
Default: TRUE
| Parameter | Display name | Required | Type | Description | Allowed values | Sample values | Nullable | Declared allowed values |
|---|---|---|---|---|---|---|---|---|
| MariaDB Data Source | MariaDB Data Source | Yes | text | You can also enter a port number after a colon and a database name after a semicolon Example: servername:portnumber;databasename | "servername:portnumber;databasename" | false | ||
| database | Database | No | nullable text | Empty database name allows browsing databases in Navigator. | "databasename" | true | ||
| CreateNavigationProperties | Auto-detect foreign key dependencies | No | nullable logical | A logical value that sets whether to generate navigation properties on the returned tables. Navigation properties are based on foreign key relationships reported by the driver. These properties show up as virtual columns that can be expanded in the query editor, creating the appropriate join. If calculating foreign key dependencies is an expensive operation for your driver, you may want to set this value to false. Default: TRUE |
true; false | true | [true, false] |