| Scroll ignore | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||
This page will walkthrough the setup of PowerBI in K.
| Info |
|---|
Power BI currently only supports lineage to Snowflake, SQL Server and Oracle. Power BI API is currently rate limited. This may impact extracts where you have 200+ workspaces or groups. |
...
Step 1) Enabling PowerBI Admin APIs to be accessible to an AD Group
...
Select Direct Connect and add your Power BI details and click Next
Fill in the Source Settings and click Save & Next
Name: Give the Power BI source a name in K
Host: Must be unique. You can use http://app.powerbi.com if you only have 1 instance of Power BI.
Timeout: Default is 10, sometimes it may take longer for the API to respond, so we recommend increasing it to 20
Add the Host/Mapping details. See Host / Database Mapping for more details
Select Enable Workspace Filtering if you wish to load only select Workspaces
Add Connection Details and click Save & Next
Tenant ID: Add the Directory (tenant) ID copied from step 2
Client ID : Add the Application (client) ID copied from Step 2
Client Secret: Add the Secret ID copied from Step 2
Test your connection and click Next
If you selected Enabled Workspace Filtering select the Workspaces you want to load. If you have a lot of workspaces this may take a bit of time to load.
Click Finish Setup
...
Step 4) Schedule PowerBI source load
...