Sage Construction & Real Estate

We currently have Sage 100 Contractor being hosted on Azure VM. I would like to know if it's possible to connect Power BI to our Sage database to create dashboard from Power BI.

We are having to change our cost code format from 16 division to 50 division. Is there a way to bulk update the existing records with the new cost codes using SQL statements? If so, would you be able to recommend an expert to help with this? Regards…