Power BI On-Premises

Functionality

Support Data Objects

Crawler 

• Reports

• Sub Report Columns
  Note: The report columns can be viewed in the OvalEdge application after the Lineage is built.

• Dashboards

• Tiles

• Pages

• Datasets

• Dataflows

Lineage

• Report lineage

• ReportColumn lineage

• Lineage Sources

Connector Type

The selected connection type Power BI  is displayed by default.

If required, the drop-down menu allows you to change the connector type and based on the selection of the connection type, the fields associated with the selected connection type are displayed.

Server Type* 

Select Power BI on-premises from the drop-down list.

Credential Manager*

Select the option from the drop-down menu where you want to save your credentials:

OE Credential Manager: Power BI on-premise connection is configured with the basic Username and Password of the service account in real-time when OvalEdge establishes a connection to the Power BI On-Premise database. Users need to add the credentials manually if the OE Credential Manager option is selected.

HashiCorp: The credentials are stored in the HashiCorp database server and fetched from HashiCorp to OvalEdge.  

AWS Secrets Manager: The credentials are stored in the AWS Secrets Manager database server and fetched from the AWS Secrets Manager to OvalEdge.

For more information on Azure Key Vault, refer to Azure Key Vault

For more information on Credential Manager, refer to Credential Manager

License Add-Ons

All the connectors will have a Base Connector License by default that allows you to crawl and profile to obtain the metadata and statistical information from a datasource. 

OvalEdge supports various License Add-Ons based on the connector’s functionality requirements.

• Select the Auto Lineage Add-On license that enables the automatic construction of the Lineage of data objects for a connector with the Lineage feature.

PBIX/PBIT Source*

Select LocalDrive from PBIX/PBIT Source drop-down list which allows reading of the existing PBIT files if they are provided.

Connector Name*

Enter a connector name for Power BI on-premise. 

Users can specify a Datasource to identify the Power BI on-premise connection in OvalEdge. 

Example: Power-BI-OnPremise_db

Connector Environment

The environment drop-down menu allows you to select the environment configured for the connector from the dropdown list. For example, PROD, or STG.

The purpose of the environment field is to help you to understand that the new connector is established in an environment available at the  Production, STG, and QA.

Note: The steps to set up environment variables are explained in the prerequisite section.

Server Domain*

Enter the On-Premises Domain name.

The Power BI Report Server allows organizations to host and share reports with users within their own domain or network.

Host Name*

This is the Hostname or IP address of the Power-BI Server. Database instance URL (on-premises). Example: app.powerbi.com(Localhost (on-premises) 

Connection URL *

Enter the On-Premise Database Connection URL. It is a URL string that the JDBC driver uses to connect with a database.

Files Path*

Enter the server files path. A user needs to create or take any existing path from the OvalEdge server and paste it here.

PBIT Files Path

Enter the PBIT files path.

Connection String*

Set the Connection String toggle button to automatic to get the details automatically from the credentials provided. Alternatively, you can manually enter the string. https://app.powerbi.com/

Username*

A username is required to connect to the Power BI On-Premise server. Enter the Service Account Name established to access the Power BI-on premise environment. 

Note: Sometimes, this field is autofill filled by the web browser with the current OvalEdge user login. Please enter the Power BI-OnPremise Service Account name.

Windows Authentication(Y/N)

To validate the connection using Windows Authentication, enter 'Y'; otherwise, enter 'N'.

Password*

Password required to connect to the Power BI-OnPremise server.

Check WithCerts(Y/N)

To validate the connection using certificates, export the certificates and place them in the Java path, then enter 'Y'; otherwise, enter 'N'.

Read From NFS(Y/N)

To retrieve reports directly from the folder without connecting to the Power BI service, enter 'Y'; otherwise, enter 'N'.

Default Governance Roles*

Users can select a specific user or a  team from the governance roles (Steward, Custodian, Owner) that get assigned for managing the data asset. 

Note: The dropdown list displays all the configurable roles (single user or a team) as per the configurations made in the OvalEdge Security | Governance Roles section.  

Admin Roles

Select the required admin roles for this connector.

• To add Integration Admin Roles, search for or select one or more roles from the Integration Admin options, and then click on the Apply button.
  The responsibility of the Integration Admin includes configuring crawling and profiling settings for the connector, as well as deleting connectors, schemas, or data objects.
• To add Security and Governance Admin roles, search for or select one or more roles from the list, and then click on the Apply button.
  The security and Governance Admin is responsible for:
  • Configure role permissions for the connector and its associated data objects
  • Add admins to set permissions for roles on the connector and its associated data objects
  • Update governance roles
  • Create custom fields
  • Develop Service Request templates for the connector.
  • Create Approval workflows for the templates

No of Archive Objects*

The number of archive objects indicates the number of recent metadata modifications made to a dataset at a remote/source location. By default, the archive objects feature is deactivated. However, users may enable it by clicking the Archive toggle button and specifying the number of objects they wish to archive. 

Select Bridge*

With the OvalEdge Bridge component, any cloud-hosted server can connect with any on-premise or public cloud data sources without modifying firewall rules. A bridge provides real-time control that makes it easy to manage data movement between any source and destination. For more information, refer to Bridge Overview.

For more information, refer to Bridge Overview

S.No.

Error Messages

Description

1

Error_validate_connection

An alert message is displayed when provided details are incorrect. 

2

Failed to establish a connection; please check the credentials.

This alert message is displayed when the Username and/or Password entered is invalid. 

Crawler

Crawler settings are configured to connect to a data source and collect and catalog all the data elements in the form of metadata. Check out the crawler options to set the crawler's behavior in the  Crawler & Profiler Settings.

Access Instruction

Access Instruction allows the data owner to instruct others on using the objects in the application.

Business Glossary Settings

The Business Glossary setting provides flexibility and control over how they view and manage term association within the context of a business glossary at the connector level. 

Lineage

The lineage settings allow you to configure multiple dialects (by Selecting Source Server Type for lineage) and connection priority lists to pick the tables to build lineage.

Others

The Send Metadata Changes Notifications option is used to set the change notification about the metadata changes of the data objects.