Power BI with your accounting data

BIPeriods - Sage 50 Accounts Period Definitions

Posted by Hugh Johnson on 18-Apr-2018 08:53:56
Hugh Johnson
Find me on:

Sage 50 Accounts OData feed for Power BI

The BIPeriods table is part of thSuntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  It contains definitions of the accounting periods 1 through 12 for the currently open accounting year in Sage 50 Accounts.

This table is essential if you want automatically to detect the start and end of the financial year for a Sage 50 Accounts company.  It would be very useful for anyone such as an accountant in practice who is using Power BI to deliver reporting solutions to multiple clients.  

BIPeriods table


Column Type Description
Period Text Period # 1 through to 12 - this is the accounting period (month) e.g. "1" for April if the accounting year starts on 1st April
Description Text E.g. "Month 1, April 2017"
PeriodID Text Internal record ID for the OData feed.  Links to the BIDates table.
StartOfPeriod Date/Time First day of the period e.g. 01/02/2018
DaysInPeriod Whole Number # of days in the period - e.g. 28
EndOfPeriod Date/Time Last day of the period e.g. 28/02/2018
LastSageYearOpen True/False True if the previous year is still open in Sage
Month Text 3-alpha text description of the month of the date - e.g. "Jan", "Feb", "Mar" etc. 
MonthNum Whole Number Month # - e.g. "2" for February
Year Whole Number Calendar year that the period is in - e.g. "2018"

BIPeriods relationships

The BIPeriods table in the OData feed has no direct relationships with other tables in the data feed, but it is there to enable the definition of analysis periods in the Dates table such as "Last Year", "This Year", and "Next Year".

Sage 50 Accounts Periods Table in Power BI 

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, financial year, accounting periods, accounting year

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.


  • 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