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.
Connect to PICK Style / MultiValue Databases.
Summary
| Property | Value |
|---|---|
| Connector |  Linkar PICK Style / MultiValue Databases |
| Products | Power BI (semantic models) Power Query Online |
| Release state | Preview |
| Category | Database |
| Authentication kinds | Basic |
| Data source kind | Linkar |
| Function Reference Documentation | Linkar.Contents |
| Support link | Support |
Supported capabilities
Entry point: Linkar.Contents
Parameters
Entry point: Linkar.Contents
Required parameter count: 3
| Parameter | Display name | Required | Type | Description | Allowed values | Sample values | Nullable | Declared allowed values |
|---|---|---|---|---|---|---|---|---|
| server | Linkar Host | Yes | text | Linkar Server IP address or DNS | "127.0.0.1"; "localhost" | false | ||
| entrypoint | EntryPoint Name | Yes | text | Data account EntryPoint Name. | "DEMO" | false | ||
| port | EntryPoint Port | Yes | number | Write the EntryPoint TCP Port | 11300 | false | ||
| language | Language | No | nullable text | If you have different languages defined, write the language which you want to visualize the data | "EN" | true | ||
| freetext | Free Text | No | nullable text | Just to identify your session in Linkar Manager | "From Power Bi" | true | ||
| customvars | Custom Variables | No | nullable text | You can write here what you need to perform custom controls | "Your vars.." | true | ||
| FileName | Table Name | No | nullable text | Write the defined Table Name in Linkar Schemas. If you want to use a MV Table or SV Table you must use extended notation: TableName.MVTableName.SVTableName. For example to bring the group of Multivalues called MVItems we must write Orders.MVItems. Remember, all the Tables Names must be defined in Linkar Schemas. | "Orders" | true | ||
| SelectClause | Select Clause | No | nullable text | Use the syntax as a SELECT on the database. You can use Property Names or File Dictionary Names. | "WITH Customer = "84"" | true | ||
| DictClause | Dict Clause | No | nullable text | All Linkar Schemas Properties that are visible, separated by spaces. Only the data will be brought | "Customer Date Item IItemDescription" | true | ||
| SortClause | Sort Clause | No | nullable text | Like SELECT in the database. You can use Property Names or File Dictionary Names. | "BY Customer" | true | ||
| sqlmode | Force SQL Mode | No | nullable logical | If you activate this option data will come in SQL Mode. This mode adapts your data to the style of a SQL table | true; false | true | true | [true, false] |