Calem connector for Power BI enables fetching any table or view from Calem in R2026h (November 2026) so clients can create own dashboards. Work orders (cm_wo) are fetched from Calem to Power BI in the screenshot below. 

 Here are the steps to add data from Calem in Power BI Desktop.

  • Go to Home | Transform data | Edit parameters, set BaseUrl for your Calem. For instance,
https://acme.calemeam.com/api/search
  • Next, launch Transform Data screen: Home | Transform data | Transform data
  • Open a query window to fetch a data object (a table or view): Home | New source | Blank query (1 in screenshot above). Enter a query clause including table or view name (see the list of tables and views at Calem: Admin | Report | Data Dictionary), and optionally a where clause (the "w" parameter in Calem REST API for data search).
  • The query below fetches work orders from 1/1/2023. Calem stores datetime in GMT time zone. For instance, for US Central dashboards, query time '2023-01-01 05:59:59' is 0:00 am (2 in screenshot above).
  • Right click on the query at the bottom left and rename it to "cm_wo" (3 in the screenshot above)
= CalemBI.Query(BaseUrl, "cm_wo", " cm_wo.modified_time >= '2023-01-01 05:59:59' ")
  • You may repeat the process to bring in more objects from Calem.
  • The query below fetches all rows in department table (cm_dept) without a parameter to filter data.
  • Rename the query to "cm_dept".
= CalemBI.Query(BaseUrl, "cm_dept")

Additional Resources