Power BI Connector for kintone

Build 21.0.7930

Data Model

The connector models the kintone API as relational Tables, Views, and Stored Procedures.


Using the connector, you can work with all the tables in your account. The table schemas can be static or dynamic. The Comments table has a static schema with fixed columns, while other tables are dynamic, reflecting changes in the metadata -- when you connect, the connector retrieves table metadata from kintone to generate the table schemas.

Static schemas are defined in schema files, which makes them easy to extend. Edit the schema file to customize the column behavior of the static Comments table, to change the data type for example. The schema files are located in the db subfolder of the connector installation folder.


In some kintone apps, the user can add custom fields containing many records. The connector models these fields as dynamic subtables reflecting your changes.

Stored Procedures

Stored Procedures are function-like interfaces to kintone. They can be used to search, update, and modify information in kintone. For example, use stored procedures to execute operations on apps or work with files.


The connector models apps in the static Apps view.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930