• Home
  • Blog
  • Power BI to simPRO Integrations FAQs
Hari Iyer | SyncEzy

Hari Iyer | SyncEzy

CEO
  • Reading Icon 2 Min Read
  • Reading Icon Jun 08, 2021
simpro to power bi integration

Power BI to simPRO Integrations FAQs

SyncEzy currently offers seventeen powerful integrations between simPRO and other apps.  To help our clients, we’d like to answer some of their top questions about integrating simPRO with Power BI.

How often does the sync run?

The sync runs every night and extracts data from simPRO Backup and makes it available to connect from an external dashboard/reporting tool.

Can it be updated instantly?

No, At this stage, we’re limited by the frequency of simPRO’s database refresh.

What sort of data can be extracted?

The entire simPRO database, all  510+ tables of it, is extracted and reportable on.   Every single thing that’s entered in simPRO is available through this connection.

Which applications can I use this data to generate reports?

You can use this data in any analytics/reporting program that accepts a SQL database connection.  Typical examples include PowerBi, Tableau, Crystal reports, Klipfolio and more.

We provide a connection file to directly connect to PowerBI.

What sort of reports can be created with the data?

Job Costings, Invoices to date, Payments, Operational efficiencies, Payroll reports, Project costings, leave reports, forward planning, a Map view of timesheets, User lists based reporting, historical user lists, Overtime reports and more.

PowerBI and other systems also allow for data from multiple sources to be blended together in a single dashboard, for example taking data from simPRO and Xero together to provide a comprehensive view of Invoices.

What if I have a multi-company account?

The integration supports simPRO Multi-company out of the box.  In a multi-company setup, all companies use the same URL so the data is stored in a single database.

Does SyncEzy build the reports?

We don’t build reports for you. We provide the connection and access to data in PowerBI, You can either build your own reports or there are external service companies who can build the reports/dashboards for you.  We can refer you to companies who understand simPRO and PowerBI very well.

Have other questions?

Get in touch with our friendly sales team to discuss your Procore questions.

Author

Hari Iyer | SyncEzy
Hari Iyer | SyncEzy
CEO

Hari Iyer is the Founder and CEO of SyncEzy, a pioneering company at the forefront of data integration and automation solutions. With a deep understanding of the power oHari’s relentless pursuit of excellence and his commitment to delivering tangible results have earned SyncEzy a loyal global clientele. He is not only a successful entrepreneur but also an active contributor to the technology community, sharing his insights through thought leadership articles, speaking engagements, and mentorship programs. Hari’s ability to navigate the complexities of remote work serves as an inspiration for leaders, highlighting the importance of flexibility, work-life balance, and a results-oriented approach in today’s evolving work landscape.

If technology and a passion for solving complex business challenges, Hari has emerged as a visionary leader in the industry. Under his guidance, SyncEzy has gained widespread recognition for its deep integration solutions that seamlessly connect software applications, eliminate data silos, and enhance operational efficiency.

When not working Hari is trying to be a better father, and reading Tech news, playing FPS games and not exercising as he should.

Let us Automate your business!

We have a team ready to answer any questions and help you get started. Drop your details here and we’ll get back to you within 24 hours.