| Scroll ignore | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||
This page will walkthrough the setup of PowerBI in K.
...
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 this page Host / Database Mapping for more details
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
Click Finish SetupSave the Landing Directory for use in a later step
...
Step 4)
...
Create a json file called mapping.json which is an empty json, and place it in the landing directory
| Code Block | ||
|---|---|---|
| ||
{} |
...
Snowflake connections are automatically mapped inside the extraction process.
If you know in advance of other types of Data Source Names referenced in PowerBI you may choose to populate the file in advance like so.
...
DaxParser.parse_oracle: Encountered an unknown DSN myDSN that was not in the mapping.json
...
Schedule PowerBI source load
Select Platform Settings in the side bar
In the pop-out side panel, under Integrations click on Sources
Locate your new PowerBI Source and click on the Schedule Settings (clock) icon to set the schedule
| Info |
|---|
Note that scheduling a source can take up to 15 minutes to propagate the change. |
...
Step
...
5) Manually run an ad hoc load to test
...
Power BI
Select Platform Settings in the side bar
In the pop-out side panel, under Platform Settings click on Batch Manager
In Source Load click Run
...