LINKAR PowerBI Connector 2.0

Share This Topic
Kosday Solutions Website
More Support
Download this manual

Zoom Window Out
Larger Text | Smaller Text
Hide Page Header
Show Expanding Text
Print Topic
Send Mail Feedback
Share This Topic
Save Permalink URL

Navigation: » No topics above this level «

Connect with Linkar

When you choose the Linkar Data Source a form will be displayed with the credentials that you will need to connect to an EntryPoint.

Linkar Server must have the Power Bi Plugin activated. And all you need is to have Schemas defined.

You can make the connection in two ways:

Navegation Mode between Schemas

You will see all the Schemas defined in the EntryPoint and you may import the tables you require.

The connection data is enough:

Linkar Host	Mandatory	Linkar Server IP or Dns
EntryPoint Name	Mandatory	EntryPoint name in Linkar Server. This must be started.
EntryPoint Port	Mandatory	EntryPoint IP port.
Language	Optional	Language code for the table headings. Languages must be generated in Linkar Schemas.
Custom Variables	Optional	Free text that will be sent to the SUB.LK.MAIN.CONTROL.CUSTOM subroutine.If there is data in this field the subroutine will be called.

The first connection Power Bi will ask you for the Linkar User and Password.

All visible Schemas defined in the EntryPoint will be displayed and you can choose anyone and see its visible Properties.

The Table name format is: EntryPointName.TableName, where the TableName is the name of the defined table in Linkar Schemas. Linkar adds the EntryPoint name in order to be able to import data from different accounts in files with the same name.

Here you will see 2 more tables, these new tables refer to the MV and SV Groups defined in the ORDERS table. This table has a MV Group called MvItems and this MV Group also has an SV Group named SvDeliveryDates. Linkar converts these Groups into new tables related to the Base File.

When you choose the tables required, you will see that the relations between them are automatically loaded.

Some relations have been created using the EqualTO property of Linkar Schemas. For instance, there is a relation between the Orders and the Customers table. This relation was created with the EqualTo properties, defined in the Customers property in the LK.ORDERS Schema.