Forum Discussion
Matthias93
Helper III
Helper IIIConsuming K2 blackpearl workflow data
Hi, I'm working with a K2 plackpearl server on Azure. I would like to find a way to consume data about workflows in Power BI. This functinality is already available for K2 Apit for SharePoint: ...
I report on my K2 Blackperal workflows in Power BI, but that OData API is only available for Appit, not Blackperal. I have created some SQL views that I might publish to the community when they are better.
Product documentation is at
https://help.k2.com/help#!/K2 blackpearl/4.7
under Developer Reference -> Reference Information -> Database Reference ->K2ServerLog database/schema ERD. I downloaded the Workflow Definition ERD and Workflow Reporting ERD.
Matthias93Helper III
Helper IIIHi,
I was able to connect to the workflow data in Power BI. Thanks for helping me out. Also I don't mind imperfect SQL views ;)
Matthias93,
Glad to hear the issue is solved, you can accept appropriate reply as solution to close this thread.
Regards,