Power BI with your accounting data

BIPurchaseOrderLines - Sage 50 Accounts Purchase Orders Lines table

Posted by Hugh Johnson on 19-Apr-2018 14:15:41

Sage 50 Accounts OData feed for Power BI

This article describes the BIPurchaseOrderLines table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.   This table is derived from the underlying Sage 50 Accounts POP_ITEM ODBC table. 

This table is essential if you want to analyse your Sage 50 Purchase Orders at the product line item level.

Read More

Topics: ODBC, Power BI Desktop, OData, purchase orders, Sage 50 Accounts

BIPurchaseOrders - Sage 50 Accounts Purchase Orders table

Posted by Hugh Johnson on 19-Apr-2018 11:18:34

Sage 50 Accounts OData feed for Power BI

This article describes the BIPurchaseOrders table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  This table is derived from the underlying Sage 50 Accounts PURCHASE_ORDER ODBC table. 

This table is essential if you want to analyse your Sage 50 Purchase Orders.

Read More

Topics: ODBC, Power BI Desktop, OData, purchase orders

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