Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
https://powerbi.microsoft.com/en-us/blog/explore-your-k2-process-analytics-data-with-power-bi/
Has anyone got experience with getting the same kind of resulsts using K2 Blackpearl?
Regards,
Matt
Solved! Go to Solution.
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.
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.
Hi,
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,
Thanks for your reply, I will try and give this method a go.
Regards,
Matt
@Matthias93,
There is no built-in connector for K2 blackpearl in Power BI. You would need to contact K2 support to check if K2 blackpearl has OData feed available, it is possible to connect straight to the OData feed from Power BI Desktop.
Regards,
Lydia
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |