Power BI with your accounting data

BIMetaData - Sage 50 Accounts - data about your data

Posted by Hugh Johnson on 19-Apr-2018 16:41:44
Hugh Johnson
Find me on:

Sage 50 Accounts OData feed for Power BI

The BIMetaData table is part of the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  This table provides data about your Sage 50 dataset and your Suntico subscription.  Use this table to determine how up-to-date your Sage 50 dataset is in Power BI.

BIMetaData table

The BIMetaData table contains four rows of information as follows:

Row Key Value
1 Company Company name
2 Last Dataset Refresh Time and Date of the last time Power BI was refreshed with this dataset
3 Last new data from Sage Time and date of the most recent update from your Sage 50 system
4 Suntico Subcription Expires Time and date for the expiry of your Suntico subscription

BIMetaData relationships

The BIMetaData table in the OData feed does not carry any relationships to other tables.  

 

BIMetaData table showing last refresh times for your Sage 50 data

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, metadata, 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