Hi SyncEzy, It looks like it is almost impossible to get Power BI to connect to Simpro API. I have tried several ways without any luck. What we are trying to achieve is the ability to generate a report in realtime where Power BI connects to the backend API and report on simple things like: 1) ALL jo...

Hi Rick,

I am now getting following information

ID
_href
CompanyName
GivenName
FamilyName

with data in them

Regards,

Rom

Hi Rick,

Thanks for your response.

I have tried this previously and I get an error as below:

{"errors":[{"path":null,"message":"Invalid route.","value":null}]}

Regards,

Rom

I have tried to connect to the Simpro API https://hickorygroup.simprosuite.com/api I have created an API application within SimPro setup. I have tried using both API Key and Resource Owner Credentials as Grant Types. I am currently using Postman to connect to this API and no matter what I do to prov...

Has anyone in the Simpro community successfully implemented or even attempted to generate reports using Power BI. We have tried to generate Power BI reports using the CSV files exported from Simpro, and it works however it is a manual process. What we are after is a connection from SimPro as a datas...