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

Power BI

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

Connect Power BI to Sage 50 Accounts via Suntico. How to connect your Sage 50 data to Power BI Pro and Power BI Desktop. Free Power BI Desktop Template will save you weeks.

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.

Power BI templates for Sage 50 Accounts - an introduction

Power BI

Power BI templates for Sage 50 Accounts - an introduction

An introduction to the Suntico Power BI Templates for Sage 50 Accounts. Save yourself hours if not weeks building your reports and dashboards. Automate your data refresh. Ideal for accountants, Sage business partner as well as in-house Power BI users. Subscribe for tips, trick and templates.

In this post I introduce a series of Microsoft Power BI template files that I am introducing for anyone wanting to work with Sage 50 Accounts.

Suntico Power BI Templates for Sage 50 Accounts
  1. What are they
  2. Who are they for?
  3. When would you use them?
  4. Where can you get them?
  5. Why would you use them? 
How to update your Suntico BI Connector software

Power BI

How to update your Suntico BI Connector software

The Suntico BI Connector software is designed to receive updates automatically, but to avoid interruptions to your Sage 50 server you have a lot of flexibility over when or if these auto-updates happen. This article describes your options.

Auto-update or update now

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

How to uninstall your Suntico BI connector for Sage 50

Power BI

How to uninstall your Suntico BI connector for Sage 50

Step-by-step instructions to uninstall your Suntico BI connector for Sage 50 Accounts.

There may be times when you want to unintsall your Suntico BI connector for Sage 50, for example if you want to move the connector from one machine to another.  Just follow these steps desribed in this blog.

The 5 Ws of Power BI for SMBs and accountants

Power BI

The 5 Ws of Power BI for SMBs and accountants

The What, Who, When, Where, and Why of using Power BI with SMBs accounting data.

In this post I use the "5 Ws" to explain from the perspective of a small to medium sized business the overall concept of Microsoft Power BI.

Power BI
  1. What is Power BI?
  2. Who is Power BI for?
  3. When is Power BI used?
  4. Where would you use Power BI?
  5. Why would you use it? 
  • 1-10

Copyright © 2019,
Accounting Insights Ltd.
All Rights Reserved.

Our Office :
Unit 4, Roof Garden Offices,
Clarehall Shopping Centre,
Dublin,
Ireland
+353 1 567 4069
contact@accountinginsights.co.uk