Forum Discussion
AroFlo data via API
Hello, We currently use AroFlo as out job management system and would like to pull some data into PowerBI via the API but so far have not been able to get PBI to connect, anyone able to assist? ...
Hi RikW,
We have solved this but its not possible by connectiong to the API directly to PBI due to the limitations of the AroFlo API and call restrictions being 2000 per day. Its not enough to propoerly get access to the underlying data. The best way forward is to land the data into a data layer first e.g. a DataLake, then access that data from PowerBI. But in saying all this, these guys have done it and sell PBI dashboards out of AroFlo much more cheaply than what it would cost to build them yourself. Homepage - Dashboards By API
Cameron