BIMetaData - Sage 50 Accounts - data about your data


by Hugh Johnson, Posted on 4/19/2018 4:27:11 PM

 Power BI Desktop, OData, metadata, Sage 50 Accounts

BIMetaData - Sage 50 Accounts - data about your data

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:

RowKeyValue
1CompanyCompany name
2Last Dataset RefreshTime and Date of the last time Power BI was refreshed with this dataset
3Last new data from SageTime and date of the most recent update from your Sage 50 system
4Suntico Subcription ExpiresTime 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.  

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

 

 


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

Our Office :
Unit 4, Roof Garden Offices,
Clarehall Shopping Centre,
Dublin,
Ireland

+353 1 567 4069

[email protected]