21.2.230712.1

  • Core Connector for Power BI: 
    • Replaced custom UTC Offset by standard Time Zone.
    • Improved Power BI Setup page:
      • Removed Working Days part and moved to a button.
      • Ungrouped Calendar Type field.
      • Cleaned up instructional text.
  • Jobs Connector for Power BI:
    • Renamed app.
    • Upgraded app to v21.
    • New v2 API queries:
      • Job Ledger Entries
      • Job Planning Lines
      • Job Tasks
      • Jobs
      • Outstanding PO Lines
      • Received Not Invoiced PO Lines
    • Marked all existing queries as pending obsolete.
    • Converted permission set from XML to object type.
    • Automatically insert new v2 web services when the app is installed or upgraded.
  • Inventory Connector for Power BI:
    • Added new Purchase Lines query.
    • Added “Document No.” field to Item Ledger Entries query.

21.2.230928.2

  • Core Connector for Power BI: Made compatible with v23.

17.1.230831.1

  • Power BI Gold Core,
    Power BI Gold Finance Data Connector,
    Power BI Gold Sales Data Connector,
    Power BI Gold Purchasing Data Connector,
    Power BI Gold Inventory Data Connector:
    • Added new v2 API queries.
    • Marked all existing queries as pending obsolete.
    • Added advanced date configurations to the Power BI Gold setup page.
    • Updated assisted setup flow.

21.2.230731.1

  • Fixed web service initialisation to skip inserting legacy queries if the tenant web service already exists.

21.2.230727.4

  • Inventory Connector for Power BI:
    • Renamed app.
    • Upgraded app to v21.
    • New v2 API queries:
      • Bins
      • Inventory by Location
      • Inventory Value
      • Item Ledger Entries
      • Warehouse Entries
      • Zones
    • Marked all existing queries as pending obsolete.
    • Converted permission set from XML to object type.
    • Automatically insert new v2 web services when the app is installed or upgraded.

21.2.230712.1

  • Purchasing Connector for Power BI:
    • Renamed app.
    • Upgraded app to v21.
    • New v2 API queries:
      • Outstanding Purchase Orders
      • Purchase Item Budget Entries
      • Purchase Value Entries
      • Received Not Invoiced Purchase Orders
    • Marked all existing queries as pending obsolete.
    • Converted permission set from XML to object type.
    • Automatically insert new v2 web services when the app is installed or upgraded.
  • Sales Connector for Power BI:
    • Enforce “Item Sales Report Date Formula” field must not be blank when the “Item Sales Report Load Data Type” is set to Relative Date on the Power BI Gold Setup page.

21.2.230601.2

  • Removed Clustered property from the primary key of the Power BI Dim. Set Entry table.

21.2.230526.1

  • Finance Connector for Power BI: Added date filtering for Customer and Vendor Ledger Entries.

21.2.230504.1

  • Core Connector for Power BI,
    Sales Connector for Power BI,
    Finance Connector for Power BI:
    • Renamed app.

21.2.230411.2

  • Power BI Core, Sales Data Connector & Finance Data Connector:
    • Upgraded app to v21.
    • Converted permission sets from XML to object type.
    • Automatically insert new v2 web services when the app is installed or upgraded.
    • Marked all existing queries as pending obsolete.
    • Core: Updated the Assisted Setup flow.
    • Core: Added advanced date configurations to the Power BI Gold setup page.
  • New v2 API queries in Power BI Core:
    • Vendors
    • Customers
    • General Ledger Setup
    • Working Days
    • Salesperson/Purchasers
    • Locations
  • New v2 API queries in Power BI Gold Sales Data Connector:
    • Item Budgets
    • Outstanding Sales Orders
    • Sales Item Budget Entries
    • Sales value Entries
    • Shipped Not Invoiced Sales Orders
  • New v2 API queries in Power BI Gold Finance Data Connector:
    • Customer Ledger Entries
    • Vendor Ledger Entries
    • Closing G/L Entries
    • Balance Sheet G/L Entries
    • G/L Account Categories
    • G/L Accounts
    • G/L Budget Entries
    • G/L Budgets
    • Income Statement G/L Entries

17.1.221021.1

  • Power BI Gold Sales Data Connector:
    • Fixed Outstanding Amount Excl. GST not referencing Outstanding Qty.

17.1.221019.1

  • Power BI Gold Core:
    • Made assisted setup searchable.
    • Updated new app URLs.
  • Power BI Gold Sales Data Connector,
    Power BI Gold Purchasing Data Connector,
    Power BI Gold Finance Data Connector,
    Power BI Gold Jobs Data Connector,
    Power BI Gold Inventory Data Connector,
    Power BI Gold Manufacturing Data Connector    :
    • Updated new app URLs.

17.1.220622.1

  • Power BI Gold Sales Data Connector:
    • Added “Outstanding Amount Excl. VAT” field on Sales Line table.
    • Updated “PBI Gold Outstanding SO” query to use outstanding amount excl. VAT.
    • Populate “Outstanding Amount Excl. VAT” field on app upgrade and installation for all outstanding sales orders per company.

17.1.220311.2

  • Power BI Gold Core: Set “Job Queue Category” and re-run parameters on the Dimension Set job queue. 

17.1.220125.2

  • Power BI Gold Core: Added OData Feed fully formatted connection string to PBI Setup & Assisted Setup pages.

17.1.211119.1

  • Power BI Gold Core:
    • Added “Order No.” & “Salespers./Purch. Code” fields to Item Ledger Entry table.
  • Power BI Gold Sales Data Connector,
    Power BI Gold Purchasing Data Connector:
    • Updated Sales/Purchase Value Entries query to use Item Ledger Entries to avoid duplicate entries.
    • Added upgrade handler to populate values on to the new fields of Item Ledger Entries for Sales & Purchase documents.

17.1.211116.2

  • Power BI Gold Core: Fixed up Update PBI Dim Set Entries logic for performance improvements.

17.1.211020.3

  • Power BI Gold Core,
    Power BI Gold Finance Data Connector,
    Power BI Gold Sales Data Connector,
    Power BI Gold Purchasing Data Connector,
    Power BI Gold Inventory Data Connector,
    Power BI Gold Jobs Data Connector:
    • Fixed web service insertions per tenant on app installation for v19 compatibility.
  • Power BI Gold Sales Data Connector:
    • Fixed up filenames for Sales queries.

17.1.210728.1

  • Added ability to update routine filters based only on the new dimension set entries.

17.1.210723.0

  • Power BI Gold Core,
    Power BI Gold Finance Data Connector,
    Power BI Gold Sales Data Connector,
    Power BI Gold Purchasing Data Connector,
    Power BI Gold Inventory Data Connector,
    Power BI Gold Jobs Data Connector:
    • Set DataAccessIntent as ReadOnly to improve performance for all queries.
    • Increased version and target 17.1 platform.
    • Updated Item Value Entries queries in Purchasing app.

15.4.200904.1

  • Fixed permission set captions.

15.0.200824.12

  • Power BI Gold Jobs Data Connector: Initial release.
  • Power BI Gold Finance Data Connector,
    Power BI Gold Sales Data Connector,
    Power BI Gold Purchasing Data Connector,
    Power BI Gold Inventory Data Connector:
    • Renamed apps.

15.0.200715.1

  • Set Update PBI Dim Set Entries job as recurring on install.

15.0.200703.1

  • Added permission sets.

15.0.200623.1

  • Added tooltips.
  • Power BI Gold Core: Added setup action to Admin. Main Role Centre.

15.0.200602.1

  • Added “Inventory Posting Group” field to PBI Items query.
  • Power BI Gold for Inventory: Added Inventory Value query.

15.0.200429.0

  • Removed unused variables.
  • Added test suite for each data connector app.

15.0.200422.0

  • Added assisted setup wizard.

15.0.200417.0

  • Removed AU-specific fields, now unified between all locales.

14.8.200402.0

  • Corrected web service name.
  • Corrected column references for Sales & Purchasing queries.