Configuring KanBo for OData integration in PowerBI Desktop
KanBo Configuration
First, add this code to Your KanBo appsettings.json
"type": "auth.oauth",
"issuer": "oData",
"children": [
[
"cert",
{
"type": "x509-store",
"store-name": "my",
"store-location": "currentuser",
"key": "thumbprint",
"value": "THUMBPRINT",
"valid-only": false
}
]/*,client will go here*/
]
},
Replace “THUMBPRINT” with the same certificate thumbprint You’ve used for other KanBo components. Restart KanBo after saving.
After that, go to https://YOURKANBOURL/auth/odata/newclient. You will be presented with this screen:

Save both parts somewhere
Copy the client part into the appropriate part of the code You pasted below. Make sure that
- You have not omitted a coma
- You changed the “client” variable to “id” (line 3)
- Changed the URL to https://oauth.powerbi.com/views/oauthredirect.html
- Changed the name to “PowerBi OData”
Your final result should look like this:
"type": "auth.oauth",
"issuer": "oData",
"children": [
[
"cert",
{
"type": "x509-store",
"store-name": "my",
"store-location": "currentuser",
"key": "thumbprint",
"value": "21XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX55",
"valid-only": false
}
],
{
"type": "client",
"id": "5XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX0",
"secret": "uXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX=",
"url": "https://oauth.powerbi.com/views/oauthredirect.html",
"name": "PowerBi OData"
}
]
},
Save the appsettings.json and restart the KanBo app.
Configuring the PowerBI .mez file
To continue, You need a .mez file to be sent by us. If You didn’t get one, please contact us.
Start by unpacking the contents of the .mez file to a folder (either by changing the extension to .zip or using a tool like 7zip).
The contents of the folder should be similiar to this:

Edit the “KanBoPowerBiConnector.pg” file.

Edit the variables to have the “OAuth2 Config” values You have generated and saved before. After that, save the file and pack everything into a .mez file (You can do it by compressing the folder contents into a .zip file and changing the extension)
Copy the .mez file into C:\Users\YOURUSER\Documents\Microsoft Power BI Desktop\Custom Connectors
Now, open PowerBI Desktop app and go to File > Options and Settings > Options > Security and allow any extensions to load without validation or warning

Click OK to confirm
After that, to access card data of a KanBo space, click on Get Data > More…

Then search for “KanBo”

After that, You will be informed about this connector being third party.

Select “Don’t want me again for this connector” and click on Continue
Important! During the next parts You will be prompted to login to Your account used in KanBo to authenticate. Please do so.

Here, You need to fill the ODataUrl with https://KANBOURL/odata/ODataCards(SPACE ID)
After clicking “OK”, You will be presented with ready to used data
