Exposing K2 SmartObject data through the SmartObject OData API provides powerful integration with third party tools like Power BI. This topic shows you how to access the service in Power BI, so that you can analyze and chart SmartObject data using Power BI.
Using the OData service, you can build custom reports and other interfaces based on SmartObject data. Create custom reports using workflow reporting data and data stored in a line of business system as long as you have SmartObjects created for that system.
You must enable the SmartObject OData API and configure SmartObjects first. See Configuring the SmartObject OData Service. Copy the URL from the Management page for use in the Power BI OData Feed configuration.
For Power BI, you must configure the OData connection in Power BI Desktop. Once configured you can use the web and mobile interfaces of Power BI.
The OData API is an IIS-hosted app and configured with Basic authentication that requires your Active Directory username and password (or Azure Active Directory if K2 is in the cloud).
Power BI caches the SmartObject data. To update these data use the following steps:
You must create the connection to the K2 SmartObject OData API in Power BI Desktop. Once the data is cached there, you can use the Power BI web and mobile interfaces to design reports. Configure the credentials for refreshing the data using Basic authentication as shown below:
Enter the Active Directory User name and Password.