--- search: boost: 0.3 --- # Adding a Power BI Online Connection (Deprecated) ## Deprecated The Power BI Online (V1) plugin has been deprecated. You can use the [Power BI Online (V2)](./zeenea-connector-powerbi-saas-v2.md) connector instead. ## Prerequisites * A user with sufficient [permissions](#user-permissions) is required to establish a connection with PowerBI Online. * Zeenea's scanner traffic flows towards Power BI's instance and Azure must be open. Refer to the following: * [https://login.microsoftonline.com](https://login.microsoftonline.com) * [https://api.powerbi.com](https://api.powerbi.com) !!! note You can find a link to the configuration template in [Zeenea Connector Downloads](zeenea-connectors-list.md). ## Supported Versions The Power BI Online connector is compatible with the product online version. ## Installing the Plugin The Power BI Online plugin can be downloaded here: [Zeenea Connector Downloads](./zeenea-connectors-list.md) !!! warning "Attention" Updating the connector to version 1.7.0 from a previous version requires a data migration for the "Data process" type objects. Please contact customer service to assist you in this migration. For more information on how to install a plugin, please refer to the following article: [Installing and Configuring Connectors as a Plugin](./zeenea-connectors-install-as-plugin.md). ## Declaring the Connection Creating and configuring connectors is done through a dedicated configuration file located in the `/connections` folder of the relevant scanner. The scanner frequently checks for any change and resynchronises automatically. Read more: [Managing Connections](../../features-applications/administration/zeenea-managing-connections.md) In order to establish a connection with a PowerBI Online instance, specifying the following parameters in the dedicated file is required: | Parameter | Expected value | |----------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | `name` | The name that will be displayed to catalog users for this connection. | | `code` | The unique identifier of the connection on the Zeenea platform. Once registered on the platform, this code must not be modified or the connection will be considered as new and the old one removed from the scanner. | | `connector_id` | The connector type to use for the connection. Here, the value must be `powerbi` and this value must not be modified. | | `connection.tenant` | Tenant's technical identifier | | `connection.url` | Connection address. Default value `https://api.powerbi.com`. | | `connection.oauth.client_id` | Application ID (client) as defined in Azure | | `connection.oauth.client_secret`| Client's secret | | `connection.oauth.endpoint` | API Scanner endpoint. Must respect following format: `https://login.microsoftonline.com//oauth2/v2.0/token` | | `dsn.configuration` | To define the list of DSNs configured in PowerBI Desktop. Must be filled in to get the lineage to external sources from DSNs. See the template to complete the field. | | `cache.path` | (Optional) To customize the cache disk storage path. Default value in the scanner cache folder. | | `proxy.scheme` | Depending on the proxy, `http` or `https` | | `proxy.hostname` | Proxy address | | `proxy.port` | Proxy port | | `proxy.username` | Proxy username | | `proxy.password` | Proxy account password | | `path.cache` | (Optional) To define a cache custom path. Used to avoid PowerBI API call limits. The connector will store workspace information in a file on disk during inventory. This property must target an existing file on disk. You can both set an absolute or a relative path, however, relative paths are dependent of the current directory at the scanner launch time.
Filter use to keep or not workspaces and reports.
Example:
`filter = "workspace starts with 'zeenea_' and not report ends with 'test'"` | | `filter` | Filter use to keep or not workspaces and reports. Example: `filter = "workspace starts with 'zeenea_' and not report ends with 'test'"` | | `contact.role_filter` | Enables you to extract only the contacts that do have a role matching the filter. To achieve this, use the `role` key to filter the contacts. Example: `contact.role_filter = "role in ('Owner', 'Read')"` | ## User Permissions In order to collect metadata, the running user's permissions must allow them to access and read reports that need cataloging. The user must be able to do the following: * Get the client identifier and associated secret. * Register an application as a service principal in the Azure environment. To communicate with Power BI, the connector uses the option suggested in paragraph [Create a new client secret](https://docs.microsoft.com/en-us/azure/active-directory/develop/howto-create-service-principal-portal#option-3-create-a-new-client-secret) from the Microsoft documentation. * Add the service principal to Power BI group. Once the client id and secret are obtained with the necessary rights, the service principal must be added as a user of a security group authorized to browse workspaces. To do so, do the following: 1. **Create an Azure AD group**. See the documentation above to create a group with reading access to all the workspaces. More information on how to create Azure AD Group can be found here: https://docs.microsoft.com/en-us/power-bi/enterprise/read-only-apis-service-principal-authentication. 2. **Add a service principal to the Azure AD group**. !!! note The service principal must not have specific rights (e.g., `Tenant.Read.All`) related to Power BI in the Azure AD configuration as this could generate conflict with security group rights on the Power BI side. ### API Scanner Authorization Documentation about the configuration of this specific access is described here: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-metadata-scanning-setup ### Retrieving Page Names from a Report To retrieve the list of page names from a report, the connector uses the API: `/groups/[workspace ID]/reports/[report ID]/pages` For this service to return the list, the service principal used by the connector must be added as a viewer: 1. Go to the Workspace. 2. Click on "Manage access" then "Add people". 3. Search for the service principal, select "Viewer", then add. If this action is performed after importing a report, the list of pages will be automatically added to the visualization on its next update. ## Rich Filters ## Workspaces and Reports Starting with version 1.11.0 the connector has a rich filter available that enables you to extract only the Workspaces and Reports that do have names matching the filter. | Criteria | Description | | :--- | :--- | | workspace | The name of the Workspace | | report | The name of the Report | #### Example: `filter = "workspace starts with 'zeenea_' and not report ends with 'test'"` ## Contacts Starting with version 1.9.0 the connector has a rich filter available that enables you to extract only the contacts that do have a role matching the filter. | Criteria | Description | | :--- | :--- | | role | The role name to filter. The values list is available [here](https://learn.microsoft.com/fr-fr/rest/api/power-bi/admin/workspace-info-get-scan-result#reportuseraccessright). | #### Example: `contact.role_filter = "role in ('Owner', 'Read')"` Read more: [Filters](../scanners/zeenea-filters.md) ## Data Extraction To extract information, the connector runs successively the following API requests: * **GET**` https://api.powerbi.com/v1.0/myorg/admin/workspaces/modified`: To get the workspaces list excluding personal workspaces. * **POST**` https://api.powerbi.com/v1.0/myorg/admin/workspaces/getInfo`: * Parameter: Workspaces list (100 workspaces limit) * Response: Scan identifier * **GET** `https://api.powerbi.com/v1.0/myorg/admin/workspaces/scanStatus/`: * Parameter: Scan identifier * Response: Scan status: `NOT_STARTED`, `RUNNING`, `SUCCEEDED` * **GET** `https://api.powerbi.com/v1.0/myorg/admin/workspaces/scanResult/`: * Parameter: Scan identifier * Response: Object with all the metadata of report from scanned workspaces ## Collected Metadata ### Inventory Collects the list of reports accessible by the user. ### Lineage The Power BI Online connector is able to retrieve the lineage between datasets that have been imported to the catalog. Datasets from other connections must have been previously imported to the catalog to be linked to the Power BI Online dataset through a new Data Process object. This feature is available for the following systems and, for it to work, an additional parameter is needed in **the configuration file of the source system connection** as configured in the Power BI Online connection configuration panel. For example, if the Power BI dataset comes from a SQL Server table, then a new alias parameter must be added in the SQL Server connection configuration file. Table summarizing the possible values of the `alias` parameter to be completed in the data source configuration file. | Source System| Model | Example | | :--- | :--- | :---- | | [SQL Server](./zeenea-connector-sqlserver.md) | Server name:port/Database name | `alias = ["zeenea.database.windows.net:1433/db"]` * | | [BigQuery](./zeenea-connector-google-bigquery.md) | BigQuery project identifier | `alias = ["zeenea-project"]` | | [AWS Redshift](./zeenea-connector-aws-redshift.md) | Server name:port/Database name | `alias = ["zeenea.cthwlv3ueke2.eu-west-3.redshift.amazonaws.com:5439/database"]` | | [AWS Athena](./zeenea-connector-aws-athena.md) | N/A | N/A | | [Snowflake](./zeenea-connector-snowflake.md) | Server name/Database name | `alias = ["kn999999.eu-west-1.snowflakecomputing.com/ZEENEA""]` * | | [Oracle](./zeenea-connector-oracle.md) | Server name:port/Service Name | `alias = ["oracle.example.com:1521/XE"]` | | [Denodo](./zeenea-connector-denodo.md) | Server name:ODBC port | `alias = ["denodo.database.com:9996"]` | !!! note The connector creates a data process object for each dataset from Power BI Online to represent the link with the source dataset (even if the source dataset is not present in the catalog). ### Visualization A visualization object is a Power BI report. * **Name** * **Source Description** * **Contacts** * **Technical Data**: * Report WebURL: Link to the report * Report Type * Workspace Name * Application: URL to the PowerBI application which this report is attached * Source Server Name * Endorsement * Certified By * Created By * Creation Date * Modified By * Modified Date * Report's page ### Dataset A dataset is a table included in a dataset PowerBI. * **Name** * **Source Description** * **Technical Data**: * PowerBI Dataset: Name of the PowerBI dataset * Power Query ### Field Dataset field or measure. * **Name** * **Source Description** * **Type** * **Can be null**: Not supported. Default value `false`. * **Multivalued**: Not supported. Default value `false`. * **Primary Key**: Not supported. Default value `false`. * **Technical Data**: * Technical Name * Native type * DAX Measure ### Data Process To represent the data flow from an external source, a Zeenea Data Process will be created for each Power BI Online Dataset. * **Name**: `import dataset_name` ## Object Identification Keys An identification key is associated with each object in the catalog. In the case of the object being created by a connector, the connector builds it. More information about unique identification keys in this documentation: [Identification Keys](../../features-applications/studio/stewardship/zeenea-identification-keys.md). | Object | Identification Key | Description | |---------------|----------------------------------------|-------------| | Visualization | code/group id.report.id | - **code**: Unique identifier of the connection noted in the configuration file
- **group id**: Power BI Online Group technical identifier
- **id**: Power BI object technical identifier | | Dataset | code/group id.dataset.id | - **code**: Unique identifier of the connection noted in the configuration file
- **group id**: Power BI Online Group technical identifier
- **id**: Power BI object technical identifier | | Field | code/group id.dataset.id/field name | - **code**: Unique identifier of the connection noted in the configuration file
- **group id**: Power BI Online Group technical identifier
- **id**: Power BI object technical identifier
- **field name** | | Data process | code/data process name | - **code**: Unique identifier of the connection noted in the configuration file
- **data process name** |