Yes. Krokul CRM has a Power Query connector for Power BI. In Get Data you choose Krokul, paste an API key and pick reports or registers, and Power BI loads them as tables that refresh on schedule. For live tiles, Krokul events push rows into a Power BI semantic model through the Krokul app in Zapier.
Automation platformsZapier
The Krokul connector shows a navigator with Krokul objects. You tick deals, payments and documents, and Power BI loads them as related tables keyed by the deal ID. A measure then compares signed amounts with money received by month and by manager.
The navigator also lists the Krokul reports for stage conversion, time on stage, DSO and ABC and XYZ segments. Each loads as a table calculated by the Krokul server, so the Power BI report shows the same numbers as the Krokul dashboard.
After you publish the report, an on-premises data gateway with the Krokul connector refreshes the semantic model on schedule. The connector reads changed records page by page and respects the Retry-After header when Krokul asks it to slow down.
The Krokul trigger Payment Received starts a Zap, and the Microsoft Power BI action Add Dataset Row adds the amount and currency to a push semantic model. A pinned dashboard tile updates as soon as the row arrives.
| Power BI | Direction | Krokul | When |
|---|---|---|---|
| Get Data → Krokul connector, navigator tables | Krokul → Power BI | Deals, client companies, contacts, documents, payments, tasks | On each refresh of the semantic model |
| Navigator report tables | Krokul → Power BI | report/api-conversion, report/api-stageDuration, report/api-dso, report/api-segments, report/api-run | On each refresh |
| Connector credentials (Key) | Power BI → Krokul | Krokul API key with read scope and role | On every request |
| Scheduled refresh through an on-premises data gateway | Krokul → Power BI | The same tables | On the refresh schedule |
| Push semantic model (Add Dataset Row in Zapier) | Krokul → Power BI | Krokul triggers Payment Received, Deal Won, Deal Lost | At the moment of the event |
| Refresh Dataset (Zapier) | Krokul → Power BI | Krokul trigger Invoice Paid | When an invoice is paid in full |
Yes. The Krokul Power Query connector appears in Get Data once installed, and it loads Krokul objects and reports as tables.
Microsoft allows up to eight scheduled refreshes a day on shared capacity and up to 48 on Premium. Each refresh reads Krokul again through the gateway with your key.
Stage conversion, average time on stage, DSO, ABC and XYZ segments, discipline, and any source, measure and dimension from the Krokul report engine.
The report shows what the Krokul key in the data source can read. Pick a key whose role and scope match the audience, and use row-level security in Power BI for finer splits.
The connector reads Krokul data and does not write back. Microsoft keeps the creation of new push semantic models open until October 31, 2027, so live tiles from events suit short-term monitoring more than long-term models.
Tell us which service you use and what should move between it and Krokul. We reply with the way to do it and when it will be ready.
Request received. We reply to your email.
Microsoft and Power BI are trademarks of the Microsoft group of companies. Krokul is not affiliated with Microsoft.