OData Integration for Power BI and Tableau

Overview

๐Ÿ“˜

Support for OData Integration

This Integration is only supported for PowerBI and Tableau

LeanIX enables you to integrate with Power BI and Tableau business intelligence tools. Integration with Power BI and Tableau tools will allow you to strengthen your ad-hoc reporting capabilities above and beyond what LeanIX already provides.

The current OData integration provides a read-only connector to export workspace data to the Power BI and Tableau business intelligence tools. Since this is only a one-way integration, importing data back into the LeanIX workspace is not possible. The current integration supports OData version 4.

High Level Steps

Within LeanIX

1

Enable OData Integration within the admin's "Integrations" area

2

Create and save searches with the required fields within the "Table View"

3

Set "Saved Searches" as "Unrestricted" and share them to OData within the "Saved Search Settings"

Within Power BI/Tableau

1

Complete steps (1-3) from above

2

Access the endpoint of the work space with an access token (can be generated in the administration area. [See technical user documentation])

3

Select "Saved Searches"

4

Load "Saved Searches" within the desired tool

Video Tutorial

Sharing Data within the LeanIX Inventory

  1. You can enable (OData Sharing) for shared saved searches within the settings of a saved search.

๐Ÿ“˜

Information

  • OData Sharing is disabled when the search is read restricted.
  • Avoid usage of the dot(.) and @ in the column names as this interferes with the annotations in OData.
  1. Within "Manage Saved Searches," you can see if OData is enabled for the saved search.

  1. You can find the "Manage Saved Searches" screen with options as follows:
    Step 1: In the main navigation, click on Inventory
    Step 2: Then, click on Manage Searches in the bottom left-hand corner
  1. When you try to delete a saved search, which is enabled for the OData, you will get a pop-up message asking you to confirm the deletion.
  1. You can choose the fields to be shared by OData via the "Table View" Editing. If you change the visibility of any fields, make sure to save the search.

Loading OData Feed into Power BI

LeanIX exposes an OData endpoint that allows you to import your saved searches (also referred to as bookmarks) into PowerBI. The endpoint can be accessed via the following URL schema, either referencing the domain (if SSO is enabled) or, alternatively, the instance:

https://<customer-domain>.leanix.net/services/import-export/v1/odata/BookmarkService.svc/
Example: https://eu-5.leanix.net/services/import-export/v1/odata/BookmarkService.svc/

// Alternative endpoint with technical property names (e.g. "Application_displayName" instead of "Display Name")
https://<customer-domain>.leanix.net/services/import-export/v1/odata/BookmarkDataService.svc/

Authentication

Authentication is currently handled via the Basic Authentication, a mechanism that is commonly supported and available in most popular BI tools on the market.

Please provide the endpoint with the following credentials:

User namePassword
API token

You can manage your access tokens under Administration โ†’ Developers โ†’ Technical Users

๐Ÿ“˜

Important

Please note that in the User name section, you have to input the API token (not the name of the technical user that is created for the API token).

You will use this API token in the next steps.

Integration

Microsoft PowerBI already comes with an OData Feed connector. This makes querying the exposed, saved searches simple. To import your data, follow the steps below:

Step 1: Under "Get data", search for OData to find the OData Feed connector. Continue by clicking the "Connect" button.

Step 2: In the next dialog, enter the URL to your OData endpoint and continue.

Step 3: If this is your first time connecting to the OData Feed, you will be prompted to choose a way to authenticate with the endpoint. Select the Basic tab in the left navigation panel and provide your credentials as mentioned above.

๐Ÿ“˜

Information

Please note that in the User name section, you have to input the API token (not the name of the technical user that is created for the API token)

Due to OData limitations the names of your saved searches are normalized.

Step 4: Now, your connection should be established. You should be able to see a list of exposed saved searches/bookmarks.

Step 5: You also have the option to load or transform the data as desired.

Changing Credentials

If you need to change your credentials, use the following steps:

Step 1: Click the File button on the menu bar.

Step 2: Choose Options and settings and then Data source settings.

Step 3: Select your desired domain and click on Edit permissions

Step 4: Click on the Edit button

Step 5: Switch to the Basic tab and enter your new token.

Loading OData Feed into Tableau

LeanIX exposes the OData endpoint that allows you to import your saved searches (also referred to as bookmarks) in Tableau. The endpoint can be accessed via the following URL schema:

https://<customer-domain>.leanix.net/services/import-export/v1/odata/BookmarkService.svc/

// Alternative endpoint with technical property names (e.g. "Application_displayName" instead of "Display Name")
https://<customer-domain>.leanix.net/services/import-export/v1/odata/BookmarkDataService.svc/

Authentication

Authentication is currently handled via Basic Authentication, a mechanism that is commonly supported and available in most popular BI tools on the market.

Please provide the endpoint with the following credentials:

Now, your connection should be established. You should be able to see a list of exposed saved searches/bookmarks.

You can drag and drop the exported fields of your searches within 'Sheets'.

๐Ÿ“˜

Information

Data will remain shared with the BI tool even after disabling the OData integration in the settings as long as the sharing of the individual 'Saved Search' is not disabled actively in the 'Saved Search details'.

Resources

Official OData Tableau Documentation
Official OData Power BI Documentation