Enterprise Data Catalog Scanner Configuration Guide > Configuring Business Intelligence Resources > Microsoft Power BI
  

Microsoft Power BI

Microsoft Power BI is a business intelligence tool that allows you to connect data and create dashboards that can be shared.

Objects Extracted

The Microsoft Power BI resource extracts metadata from the following assets in a Microsoft Power BI data source:

Permissions to Configure the Resource

You need a user account with Power BI administrator privileges.
Note: Because of the constraint that the Microsoft Power BI Admin REST API imposes, you need a user account with Power BI administrator privileges.
In the Azure Active Directory, configure the read permission and the following API permissions on the registered application for the Power BI service:

Prerequisites

Before you create a Power BI resource, perform the following steps:
  1. 1. Create an Azure Active Directory tenant.
    2. Note: You can use an existing tenant if it is configured in the Azure Active Directory.
    For more information about creating a new tenant in the Azure Active Directory, see the Microsoft documentation.
  2. 2. Create a new user in the Azure Active Directory or use an existing Azure Active Directory user.
  3. 3. Assign the Power BI administrator privileges to the new or existing Azure Active Directory user.
    4. For more information about assigning Power BI administrator privileges, see the Microsoft documentation.
  4. 4. Register the application in Azure Active Directory to access the Microsoft Power BI content. Use the client ID received to create the Power BI resource.
    5. Note: To register an application in the Azure Active Directory, the user account must have the Application administrator privileges.
    For more information about registering an application in Azure Active Directory, see the Microsoft documentation.
  5. 5. Provide Microsoft Power BI Service API permissions to the application, and grant access to all the Power BI Service APIs.
  6. 6. Select the new or existing Azure Active Directory user as the owner of the application.
  7. 7. Set the Treat application as public client property to Yes in the registered application.

Resource Connection Properties

The General tab includes the following properties:
Property
Description
Username
Username of the administrator to connect to the Microsoft Power BI server.
Password
Password of the administrator account to connect to the Microsoft Power BI server.
Client ID
Client ID to connect to the Microsoft Power BI server.
The following table describes the properties that you can configure in the Source Metadata section of the Metadata Load Settings tab:
Property
Description
Enable Source Metadata
Enables metadata extraction
Workspace
The type of workspace. Workspace is a shared environment, where a group of people can create collections of dashboards and reports.
Memory
The memory value required to run a scanner job.
Specify one of the following memory values:
  • - Low
  • - Medium
  • - High
Note: For more information about the memory values, see the Tuning Enterprise Data Catalog Performance article on How To-Library Articles tab in the Informatica Doc Portal
JVM Options
JVM parameters that you can set to configure scanner container. Use the following arguments to configure the parameters:
  • - -Dscannerloglevel=<DEBUG/INFO/ERROR>. Changes the log level of scanner to values, such as DEBUG, INFO, or ERROR. Default value is INFO.
  • - -Dscanner.container.core=<No. of core>. Increases the core for the scanner container. The value must be a number.
  • - -Dscanner.yarn.app.environment=<key=value>. Key value pair that you need to set in the Yarn environment. Use a comma to separate the multiple key value pairs.
  • - -Dscanner.pmem.enabled.container.memory.jvm.memory.ratio=<1.0/2.0>. Increases the scanner container memory when pmem is enabled. Default value is 1.
Track Data Source Changes
View metadata source change notifications in Enterprise Data Catalog.

Unsupported Features