Hi there.
Power BI is really good at connecting to a variety of different data types, and would play very well with software like SYSPRO, their back-end is SQL Server after all.. (what if it's cloud?) However may I add that it really depends what you are looking for and what your business needs. If you have an IT department in your org that is familiar with reverse engineering an ERP for reporting and data modeling techniques, and depending on scope of the project and time you can afford, then building from the ground up and directly using Power BI might be a good option.
Otherwise there are a few pre-built data model and analytics solutions out there that will take you instantly to 80%, and integrates well with the Microsoft stack and Power BI. This includes my organization and product: ZAP Data Hub. We are a Microsoft Partner and SYSPRO Global ISV with an automated datawarehouse SaaS product on Azure. So you'd be leveraging a pre-built/certified DW generated on Azure. We have our own Visualization layer and pre-built reports and dashboards, we understand ERP and by experience I can tell you that modeling data against ERPs always sound feasible, and it is, but it is far from being straight forward, and in many ways can only be done if you're very close to the ERP Engineering team. Leveraging a tool that deeply integrates and understands the core ERP schema and specific functions as well as working with a software vendor that specialises in ERP data models can take you to the next level, and be a way more cost effective solution. You're just more productive at doing the things you should deliver for your business, instead of reinventing the wheel.
Ah, have I also mentioned we have pre-built Power BI Apps for SYSPRO that integrate with our Azure data warehouses? Just search for "ZAP Data Hub" on the Power BI AppSource.
All the best with your data project!
