Configuring KanBo for OData integration in PowerBI Desktop

Table of Contents

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

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