Power BI Resource Configuration
Before you configure your scanner, make sure you meet the prerequisites. Read our guide on Power BI integration requirements to double-check.
This configuration can be setup by creating a new connection on Admin UI > Connections tab or editing an existing connection in Admin UI > Connections > Reporting & BI > Power BI > specific connection. New connection can also be created via Manta Orchestration API General Walkthrough Example.
Using Azure Extraction Mode
This mode is used when reports are stored in Azure using Power BI Pro or Power BI Premium. You can set up and change these properties in Connections → Add Connection → PowerBI.
|
Property name |
Description |
Example |
|---|---|---|
|
powerbi.extractor.mode |
Determines how to extract Power BI reports — set to AZURE to use the Azure extraction mode |
AZURE |
|
powerbi.extractor.folder |
Name of a resource representing an output subdirectory for extracted reports |
PowerBIAZURE |
|
powerbi.extractor.encoding |
Encoding of automatically extracted Power BI reports and other object definitions. See Encodings for applicable values. |
UTF-8 |
|
powerbi.azure.username |
User name for logging in to Azure |
|
|
powerbi.azure.password |
Password for logging in to Azure |
psswd |
|
powerbi.azure.applicationID |
Application ID of the Power BI application registered in Azure |
7ef2eab1-7c9c-452e-8574-75f3af3f22ef |
|
powerbi.azure.clientSecret |
ClientSecret obtained when registering an application in Azure |
ANdPNuEEX4oitJfghIr7+YNJoF0x98t9Xho4ZvNrEKA= |
|
powerbi.azure.directoryID |
Directory ID of the Power BI application registered in Azure |
1b2e27a9-48a1-4213-89c8-48d47914480f |
|
powerbi.azure.include |
Regular expression used to include reports in the extraction. It is matched up with the workspaces and reports in Power BI Pro in the form of a workspace/report (without the .pbix/.pbit extension), or is ignored if left blank. See Power BI Include/Exclude Options for more details. |
|
|
powerbi.azure.exclude |
Regular expression used to exclude reports from the extraction. It is matched up with the workspaces and reports in Power BI Pro in the form of a workspace/report (without the .pbix/.pbit extension), or is ignored if left blank. See Power BI Include/Exclude Options for more details. |
|
|
powerbi.extraction.method (as of R42.2) |
Set to Agent:default when the desired extraction method is the default Manta Extractor Agent, set to Agent:{remote_agent_name} when a remote Agent is the desired extraction method, set to Git:{git.dictionary.id} when the Git ingest method is the desired extraction method. For more information on setting up a remote extractor Agent please refer to the Manta Flow Agent Configuration for Extraction documentation. For additional details on configuring a Git ingest method, please refer to the Manta Flow Agent Configuration for Extraction:Git Source documentation. |
default Git agent |
Using Local Extraction Mode
This mode is used when reports are stored using Power BI Report Server. You can set up and change these properties in Connections → Add Connection → PowerBI.
| Property name | Description | Example |
|---|---|---|
| powerbi.extractor.mode | Determines how to extract Power BI reports — set to LOCAL to use the Local extraction mode | LOCAL |
| powerbi.extractor.folder | Name of a resource representing an output subdirectory for extracted reports | PowerBI_LOCAL |
| powerbi.extractor.encoding | Encoding of automatically extracted Power BI reports and other object definitions. See Encodings for applicable values. | UTF-8 |
| powerbi.local.address | Address of the Power BI Report Server to extract reports from | 192.168.0.16 |
| powerbi.local.port | Port where Power BI Report Server listens for connections | 80 |
| powerbi.local.scheme | Scheme used to connect to the Power BI Report Server | http |
| powerbi.local.folder | Main folder where the reports are stored, found in the path to the report server (more information below this table) | BIReports |
| powerbi.local.username | User name | powerbi_user |
| powerbi.local.password | User password | powerbi_psswd |
| powerbi.local.include | Regular expression used to include reports in the extraction. It is matched up with the full path of the report, including directories on the Power BI server in the form of a directory-tree/report (without the .pbix/.pbit extension), or is ignored if left blank. See Power BI Include/Exclude Options for more details. | TestFolder/.*/.*2019 |
| powerbi.local.exclude | Regular expression used to exclude reports in the extraction. It is matched up with the full path of the report, including directories on the Power BI server in the form of a directory-tree/report (without the .pbix/.pbit extension), or is ignored if left blank. See Power BI Include/Exclude Options for more details. | TMP/.* |
If you are unsure about the scheme, address, port, or local folder, all these can be obtained from the URL used to access the Power BI Report Server:
{powerbi.local.scheme}://{powerbi.local.address}:{powerbi.local.port}/{powerbi.local.folder}/browse; for example, http://192.168.0.1:80/BIReports/browse.
Common Scanner Properties
This configuration is common for all Power BI source systems and for all Power BI scenarios, and is configure in Admin UI > Configuration > CLI > Power BI > Power BI Common. It can be overridden on individual connection level.
| Property name | Description | Example |
|---|---|---|
| powerbi.input.dir | Directory for automatically extracted Power BI reports | ${manta.dir.temp}/powerbi/${powerbi.extractor.folder} |
| powerbi.manualInput.dir | Directory with manually extracted power query scripts (more in How to Manually Insert Power Query Script) | ${manta.dir.input}/powerbi/${powerbi.extractor.folder} |
| powerbi.extractor.proxy.toggle (as of R42.8) | Whether or not the requests to PowerBI APIs should be sent through an outbound proxy. If true, proxy details such as host and port are needed. |
false |
| powerbi.extractor.proxy.host (as of R42.8) | The base URL of the proxy. | proxy.domain.org |
| powerbi.extractor.proxy.port (as of R42.8) | The port of the proxy. (Default value: 8080) | 8080 |
| powerbi.extractor.proxy.username (as of R42.8) | The proxy authentication username, if any. Leave blank if the proxy does not use Password Authentication | proxyUser |
| powerbi.extractor.proxy.password (as of R42.8) | The proxy authentication password, if any. Leave blank if the proxy does not use Password Authentication | proxyPassword |