Microsoft Power BI (Local) connection
To access your data in Power BI Report Server, create a connection asset for it first.
Microsoft Power BI is a business analytics solution that includes products and services for business intelligence (BI) reporting and data visualization. The qualifier local describes the extraction mode that is used to extract business intelligence report definitions. Local extraction connects to Power BI Report Server.
Create a connection to Microsoft Power BI (Local)
To create the connection asset, you need the following connection details:
- Local server address: Hostname or IP address of the Power BI server.
- Local server port: The default value is 80.
- Local server folder: The folder on the server where reports are stored, for example,
Reports
. - Username and Password to the Power BI server.
To use the SSL security protocol, select Port is SSL-enabled. The certificate must be in the MANTA Automated Data Lineage truststore.
For Credentials, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.
Choose the method for creating a connection based on where you are in the platform
In a project
Click Assets > New asset > Data access tools > Connection. See Adding a connection to a project.
In the Platform assets catalog
Click New connection. For more information, see Adding platform connections.
Next step: Add data assets from the connection
Run metadata import to add assets and lineage information to a catalog.
Where you can use this connection
You can use the Microsoft Power BI (Local) connection in the following workspaces and tools:
Projects
- Metadata import (Watson Knowledge Catalog). For information about the supported product versions and other prerequisites when connections are based on MANTA Automated Data Lineage for IBM Cloud Pak for Data scanners, see the Lineage Scanner Configuration section in the MANTA Automated Data Lineage on IBM Cloud Pak for Data Installation and Usage Manual. This documentation is available at https://www.ibm.com/support/pages/node/6597457.
For metadata import (lineage), advanced metadata import must be enabled and a MANTA Automated Data Lineage license key must be installed. See Installing Watson Knowledge Catalog, Installing MANTA Automated Data Lineage, and Enabling lineage import.
Catalogs
- Platform assets catalog
Federal Information Processing Standards (FIPS) compliance
The Microsoft Power BI (Local) connection cannot be created in a FIPS environment.
Microsoft Power BI (Local) setup
For information about the supported product version and other prerequisites, see the Power BI topic in the Lineage Scanner Configuration section in the MANTA Automated Data Lineage for IBM Cloud Pak for Data Installation and Usage Manual. The MANTA Automated Data Lineage for IBM Cloud Pak for Data documentation is available at https://www.ibm.com/support/pages/node/6597457.
Restrictions
Connection testing when you create or update the connection doesn't work for this connection. A connection is validated when you set up a metadata import that uses the connection.
Related connections: Microsoft Power BI (Azure) connection
Parent topic: Supported connections