Collibra Community

BI Integrations

Created Nov 18, 2023

1 member

6 discussions

The BI Integrations topic in the Collibra Community is a space dedicated to discussing and resolving issues around integrating business intelligence tools like Power BI and Tableau with Collibra. It features conversations on syncing workspaces, configuring lineage harvesters, dealing with UI changes, and ensuring smooth metadata flow. Ideal for users working on BI data lineage and automation within the Collibra ecosystem.

ak13258
1 month ago
How do you filter the Power BI Edge Synchronization based on workspace name pattern matching?
Hi all, we want to sync Power BI Workspaces with Edge into a set of different domains based on the naming of the Power BI Workspace. Let's say we have a Power BI PROD, a Power BI TEST, and a Power BI DEV domain and workspaces with names: Workspace1_DEV, Workspace1_TEST, Workspace1_PROD.

Is there any way to set a pattern in the workspaceNames field of the source configuration file (e.g., '%PROD') so to ensure that the workspaces get synched into the appropriate domains?

1
brianlloyd
8 months ago
Tableau Online (now Tableau Cloud) Lineage Harvester not working with Metadata API after Tableau Upgrade 2024.2
I am looking for anyone else that is having this issue.

First - our Tableau Online Lineage Harvester on Edge integration has been working perfectly fine every week for months.

Second - We have both Tableau Online and Tableau Server integrations working so we know how to set things up and use the capabilities on Edge.

Our Tableau Online Capability is set to use both the Tableau REST API and the Metadata API (which is turned on by default for all Tableau Online instances).

The Tableau REST API allows us to catalog the Projects, Workbooks, Worksheets, Dashboards, and Data Models.

The Tableau Metadata API allows us to catalog the Tableau Data Attributes - which is needed for any realistic Lineage stitching to the underlying databases.

THE PROBLEM: Tableau Online (now Tableau Cloud) upgraded to version 2024.2 on July 1st, 2024.

Our working Tableau Lineage Harvester stopped working with an odd un-useful error of "Execution canceled because timeout of 30000 millis was reached"

If we set the REST Only flag in the Capability configuration then the job runs but we do not get any Data Attribute assets.

If we turn off the flag so that Collibra uses the REST and Metadata API then it fails quickly.

Has anyone else experienced this issue after the 2024.2 upgrade at the beginning of July?

6
mounabensouda
10 months ago
Failure to install the lineage harvester despite having the latest version of Java 17
Hello,

I would like to make a demo to my client of the lineage harvester applied to Power BI reports. I downloaded the zip file here version 2024.05

However, I can't run the script to create an empty lineage harvester configuration file because Java 17 is not detected.

Instead I get the following error message despite having the right java version. Please see picture below the error message

Could you please provide your help ?

Kind regards

Mouna

0
user_aa09d2
10 months ago
Technical Lineage Tab in BI Reports in the new UI missing
We noticed the Technical Lineage tab in BI reports and Columns is no longer visible in the new UI. We can only see it in SQL tables and columns. Is there a way to bring it back for BI reports?

6
Former User
1 year ago
Power BI Integration to DIP
We are trying to integrate BI with Collibra DIP. After going through the documentation what we understand is there are 2 different ways of integration : Edge and Lineage Harvester. One of the question is , can we use any one of them and what information we will be missing if we go ahead with EDGE connectivity?

As per documentation, I see the steps that needs to be followed :

Register application on azure and capture tenant id, client id and client secret. Update the permissions.

Grant permissions in Power Bi.

Create Domain in collibra

In EDGE, fill out the configuration.
5.Set the synchronization schedule.

Am I on the right track or is there anything I am missing?
0
chandrapapudesu
1 year ago
PowerBI enhancements
Power BI | Streamlined experience

Take the complication out of reporting processes and procedures with an enhanced Power BI experience for business users that streamlines trusted business reporting. Expanded information including DAX calculations and app report URLs are now included on Power BI asset pages. If a data set or report in Power BI is certified, the corresponding Power BI Data Model and Power BI Report assets in Collibra are now automatically certified. Additional enhancements, including improved stitching results with technical lineage, ensure users have the right information to deliver trusted business reporting.

Learn more about our latest integrations here:

What’s New in Collibra video

Collibra + Microsoft partnership page
0

How do you filter the Power BI Edge Synchronization based on workspace name pattern matching?

Tableau Online (now Tableau Cloud) Lineage Harvester not working with Metadata API after Tableau Upgrade 2024.2

Failure to install the lineage harvester despite having the latest version of Java 17

Technical Lineage Tab in BI Reports in the new UI missing

Power BI Integration to DIP