K Knowledge Base
Breadcrumbs

Power BI (via Collector method) - v2.0.0

About Collectors


Pre-requisites

  • Python 3.6 - 3.10

  • Access to Power BI

Power BI access

Setup a Service Principal with access to Power BI. You will need:

  • Application (client) ID

  • Directory (tenant) ID

  • Secret Value


Step 1: Create the Source in K

Create a Power BI source in K

  • Go to Settings, Select Sources and click Add Source

  • Select "Load from File" option

  • Give the source a Name - e.g. PowerBI Production

  • Add the Host name for the PowerBI Server

  • Click Finish Setup


Step 2: Getting Access to the Source Landing Directory


Step 3: Install the Collector

Run the following command to install the collector:

pip install kada_collectors_extractors_powerbi-#.#.#-py3-none-any.whl

Step 4: Configure the Collector

The collector requires parameters: client, secret, tenant, output_path, mask, timeout, filter_flag, filter_workspaces, and mapping for connecting to Power BI.