Power BI with your accounting data

BIDepartments - Sage 50 Accounts - Departments list

Posted by Hugh Johnson on 19-Apr-2018 16:23:34
Hugh Johnson
Find me on:

Sage 50 Accounts OData feed for Power BI

This article describes the BIDepartments table that forms part of the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.    The table provides a list of all of your Sage 50 Departments.

It is related to the BITransSplits so that if you can produce Departmental Profit & Loss reports if this is how you are using Sage 50 Departments.  You can also use this table to produce a list of Departments used in your Sage 50 system. 

BIDepartments table

 

Column Type Description
DeptID Whole Number Internal ID
DeptRef Text Dept Ref link to BITransSplits
Name Text Department name

BIDepartments relationships

The BIDepartments table in the OData feed is by default related to the BITransSplits table as shown below.  I have assumed that if you are using Sage 50 Departments to the fullest extent intended, then this is where you would want the relationship.  If you need to you can edit this in Power BI Desktop.  

 

BIDepartments relationships in Sage 50 Accounts

 

To try our this OData feed for your Sage 50 Accounts data, why not create your own Suntico BI trial account?

Create Suntico BI Trial Account 

 

Topics: Power BI Desktop, OData, Sage 50 Accounts, Departments

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