Power BI with your accounting data

How to update your Suntico BI Connector software

Posted by Hugh Johnson on 11-Apr-2018 07:42:01

Auto-update or update now

This blog describes how to update your Suntico BI connector when there is a new version available. 

Read More

Topics: Reporting, Connect Power BI to Sage 50, Sage 50, Power BI, ODBC, Sage 50cloud, Accounting

Connect Power BI to Sage 50 Accounts - Part 4 of 4

Posted by Hugh Johnson on 06-Apr-2018 16:42:43

Connect Power BI to your Sage 50 OData Feed

This blog describes part four of a four-part process to connect Power BI to Sage 50 using the Suntico BI service.  In this blog I show you how to link your Sage 50 company (or companies) that you have in your Suntico account to Microsoft Power BI.  We will look at two examples:

  1. Connecting your Sage 50 company to the "Accounting Insights for Sage 50" Content Pack on the Power BI Service.
  2. Connecting your Sage 50 company to Power BI Desktop.

You can do either or both.  Maybe it is a good idea to connect to the Content Pack first, as that will give you a ready-made dashboard and report that you can start to use right away.  Meanwhile, you can connect to Power BI Desktop and start to build out some custom reports is you alsow wish to.  To get you started with Power BI Desktop you can also download a Power BI Template file that will save you a lot of work setting up your Sage 50 model.

Let's start with the common activity that you will nee to do, and that is to generate your Power BI keys (username and password) for the Suntico BI OData feed.

Read More

Topics: Reporting, Connect Power BI to Sage 50, Sage 50, Power BI, ODBC, Sage 50cloud, Accounting

Connect Power BI to Sage 50 Accounts - Part 3 of 4

Posted by Hugh Johnson on 04-Apr-2018 10:16:16

Download and install your Suntico BI Connector

This blog describes part three of a four-part process to connect Power BI to Sage 50 using the Suntico BI service. 

Read More

Topics: Reporting, Connect Power BI to Sage 50, Sage 50, Power BI, ODBC, Sage 50cloud, Accounting

Connect Power BI to Sage 50 Accounts - Part 2 of 4

Posted by Hugh Johnson on 03-Apr-2018 19:24:44

Create your Suntico BI trial account

This blog describes part two of a four-part process to connect Power BI to Sage 50 using the Suntico BI service. 

Read More

Topics: Reporting, Connect Power BI to Sage 50, Sage 50, Power BI, ODBC, Sage 50cloud, Accounting

Connect Power BI to Sage 50 Accounts - Part 1 of 4

Posted by Hugh Johnson on 02-Apr-2018 19:45:59

Prepare Sage 50 for connection to Power BI via Suntico

This blog describes part one of a four-part process to connect Power BI to Sage 50 using the Suntico BI service. 

Read More

Topics: Reporting, Connect Power BI to Sage 50, Sage 50, Power BI, ODBC, Sage 50cloud, Accounting

Power BI with your accounting data

Time-saving tips, tricks, templates and tutorials

Subscribe to this blog for practical shortcuts to driving real insights from your accounting data with Power BI.

Expect:

  • How-to videos
  • Example reports
  • Sample formulae
  • Data modeling tips
  • Free Power BI templates
  • Tips for optimising Sage 50cloud

Subscribe to Email Updates

Recent Posts