Power BI with your accounting data

How to connect Power BI to Sage 50 Accounts

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

 Set up Sage 50 Accounts as one of your Power BI data sources

You can achieve a powerful PowerBI Sage 50 integration by setting up your Sage 50 Accounts system as an OData feed for Power BI.  By doing this, you will be able to:

  • Pull your Sage 50 Accounts data into Power BI Desktop
  • Author compelling reports based on your Sage 50 Accounts data
  • Publish these reports to the Power BI Pro service on the web
  • Create dashboards and share these across your organisation
  • Automate the data refresh from Sage 50 Accounts to Power BI
As a pre-requisite you will need Power BI Desktop, Sage 50 Accounts v22 or higher and an active  active  Suntico BI user account.  Once you have these, just follow these three steps:
  1. Set up a user in Sage 50 Accounts for the OData feed
  2. Install the OData feed connector for Sage 50 Accounts
  3. Connect Power BI to Sage 50 Accounts

Read More

Topics: Connect Power BI to Sage 50 Accounts

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