Upgrade to Power BI harvester 1.0.0.1 or newer and lineage harvester 1.3.0 or newer (deprecated)

The Power BI harvester 1.0.0.1 enables you to connect to a Collibra Data Lineage server, based on your geolocation and cloud provider.

You only have to follow this upgrade procedure when you upgrade from Power BI harvester 1.0.0.0 to Power BI harvester 1.0.0.1 and newer or if the server's geolocation or cloud provider changes.

Tip We highly recommend that you always use the newest Power BI harvester and lineage harvester.

Steps

  1. If you have strict firewall rules, allow one of the following IP addresses, based on your Collibra geolocation and cloud provider:

    • 15.222.200.199 (techlin-aws-ca.collibra.com)
    • 18.198.89.106 (techlin-aws-eu.collibra.com)
    • 13.228.38.245 (techlin-aws-sg.collibra.com)
    • 54.242.194.190 (techlin-aws-us.collibra.com)
    • 51.105.241.132 (techlin-azure-eu.collibra.com)
    • 20.102.44.39 (techlin-azure-us.collibra.com)
    • 35.197.182.41 (techlin-gcp-au.collibra.com)
    • 34.152.20.240 (techlin-gcp-ca.collibra.com)
    • 35.205.146.124 (techlin-gcp-eu.collibra.com)
    • 34.87.122.60 (techlin-gcp-sg.collibra.com)
    • 35.234.130.150 (techlin-gcp-uk.collibra.com)
    • 34.73.33.120 (techlin-gcp-us.collibra.com)

    Note IP address 15.222.200.199 is only available for Power BI harvester 1.0.0.2 and lineage harvester 1.3.1 and newer.

  2. Download Power BI harvester 1.0.0.1 or newer, from the Collibra Downloads page.
  3. Install the new Power BI harvester.
  4. Migrate your Power BI connection information in your old configuration file to the configuration file in the new Power BI harvester folder.
  5. Trigger the Power BI harvester to upload the Power BI metadata to the Collibra Data Lineage server with the new IP address:
    • Run the following command line if your configuration file is in its default location: .\powerbi-harvester.bat
    • Launch the path to the Power BI configuration file if you moved the configuration file to a different location:.\bin\powerbi-harvester.exe .\config\powerbi-harvester.conf

    Note We highly recommend that you run the Power BI harvester via command line. This enables you to follow the metadata upload and see possible errors that may occur.

  6. Download lineage harvester 1.3.0 or newer, from the Collibra Downloads page.
  7. Install the new lineage harvester.
  8. Migrate the data sources in your old configuration file to the configuration file in the new lineage harvester folder.
  9. Run the lineage harvester with the full-synccommand.
    The lineage harvester uploads your data sources to the Collibra Data Lineage server with the new IP address.
  10. Restart the DGC service in Collibra Console.

Tip For more information about Power BI and the Power BI harvester, see Power BI.

What's next?

Collibra now synchronizes your Power BI assets and relations. You can also access the technical lineage via a Power BI Column asset page.