Microsoft Power BI
Connecting Microsoft Power BI to Timbr Using Spark
- Open PowerBI
- At the top-left menu bar click on "Get Data"
- On the left hand side click on "Other"
- Search for the Spark connector. Once found choose it and click "Connect"
- After selecting the Spark connector, fill in the server information as follows and click "OK".
In the server details, make sure to add “/timbr-server” after the port like the example below
Server:
HTTP://<the platform URL>:80/timbr-server/ontology/<ontology_name>or
HTTPS://<the platform URL>:443/timbr-server/ontology/<ontology_name>
Protocol: HTTP
Advanced Options (optional): in case you want to limit the batch size read of the data
Data Connectivity mode: you can choose any of the two options:
A. Import = Fetches all the data from the chosen concept
B. Direct Query = Live query over the Knowledge Graph
- Next you will be required to enter your credentials - Username and Password.
The username is "token".
As for the password, to get the numerical personal token from the timbr platform, click on ‘Copy user access token’ from the home page of the platform, or open the SQL Editor in timbr and run the following command: show token
The input in Power BI should look like this:
Username = token
Password = tk_123456789…………
- After connecting, you'll be able to choose the relevant concept and click any of the 2 options:
- Load = to fetch the concept as a table with all its properties.
- Transform data = if you want to perform changes to the data.
- You’re ready to use the concepts and their relationships as virtual tables for your reports and dashboards!
When selecting a concept from the dtimbr schema, by default, the preview data won’t show if the concept has 3 relationships or more. This configuration in timbr is intended to avoid executing all the joins of a table. The configuration can be changed to allow any number of relationships to show.
Connecting Microsoft Power BI to Timbr Using Databricks
- Open PowerBI
- At the top-left menu bar click on "Get Data"
- On the left hand side click on "Online Services"
- Search for the Databricks connector. Once found choose it and click "Connect"
- After selecting the Databricks connector, fill in the server information as follows and click "OK".
In the server details, make sure to use the correct HTTP Path, including "/timbr-server/databricks/", as shown in the example below.
Server Hostname (without http://, https://, or a port): <hostname>
HTTP Path: /timbr-server/databricks/ontology/<ontology_name>
Advanced Options (optional):
Default Catalog: hive_metastore
Database: for cases where you want to limit the connection to the selected database
Automatic Proxy Discovery: this enables automatic Windows System wide automatic Proxy Discovery
Native Query (Requires Default Catalog): the native query for fetching the data
Data Connectivity mode: you can choose any of the two options:
A. Import = Fetches all the data from the chosen concept
B. Direct Query = Live query over the Knowledge Graph
- Next you will be required to enter your credentials - Username and Password.
The username is "token".
As for the password, to get the numerical personal token from the timbr platform, click on ‘Copy user access token’ from the home page of the platform, or open the SQL Editor in timbr and run the following command: show token
The input in Power BI should look like this:
Username = token
Password = tk_123456789…………
- After connecting, you'll be able to choose the relevant concept and click any of the 2 options:
- Load = to fetch the concept as a table with all its properties.
- Transform data = if you want to perform changes to the data.
- You’re ready to use the concepts and their relationships as virtual tables for your reports and dashboards!
When selecting a concept from the dtimbr schema, by default, the preview data won’t show if the concept has 3 relationships or more. This configuration in timbr is intended to avoid executing all the joins of a table. The configuration can be changed to allow any number of relationships to show.