Configuring OData Integration for Power BI Desktop

Table of Contents

KanBo configuration

  1. Go to the KanBo appsettings.json file, and add this code.
 "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*/
    ]
   },
  1. Replace “THUMBPRINT” with the same certificate thumbprint that you used for the other KanBo components.
  2. Save the changes and restart KanBo.
  3. Go to https://YOURKANBOURL/auth/odata/newclient. You will then see this screen:
  1. Save both parts somewhere.
  2. Copy the client part into the appropriate section of the code that you pasted below. Make sure that:
    • You did not omit a comma,
    • You changed the “client” variable to “id” on line 3,
    • You changed the URL to https://oauth.powerbi.com/views/oauthredirect.html,
    • You 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"
        }
    ]
   },
  1. Save the appsettings.json file and restart KanBo.

Power BI .mez file configuration

  1. To continue, you need to receive a .mez file from us. If you did not receive one, please contact us.
  2. Unpack the contents of the .mez file into a folder by either changing the extension to .zip or using a tool like 7-Zip.
  3. The folder contents should be similiar to this:
  1. Edit the “KanBoPowerBiConnector.pg” file.

  1. Edit the variables to include the “OAuth2 Config” values that you generated and saved earlier.
  2. Then, save the file and pack everything into a .mez file. You can do this by compressing the folder contents into a .zip file and changing the extension.
  3. Copy the .mez file to C:\Users\YOURUSER\Documents\Microsoft Power BI Desktop\Custom Connectors.
  4. Open the Power BI Desktop app.
  5. Go to File > Options and Settings > Options > Security.
  6. Allow any extensions to load without validation or warning.

  1. Select OK to confirm.
  2. To access card data of a KanBo space, select Get Data > More….
  1. Search for “KanBo”.
  1. After that, you will be informed that this is a third-party connector.
  1. Check the Don’t warn me again for this connector box, and then select Continue.
  2. Important: You will then be prompted to log in to the KanBo account you used to authenticate. Please do so.
  1. Here, you need to fill in the OData URL with: https://KANBOURL/odata/ODataCards(SPACE ID), and then select OK.
  2. You will be presented with data that is ready to use.

Was this article helpful?

Please, contact us if you have any additional questions.