Power BI Template for LS One

Here you can find Power BI Templates for all versions of LS One from release 2017.2 and onward.

The template includes Dashboard reports, Entity reports and the full data model with queries.

To get the solution up and running:

  1. Install the latest Power BI desktop
  2. Open the attached Power BI template (download the correct template for your LS One version below)
  3. Enter server & database information of your LS One SQL database

Subscribe to updates

If you want to get notified of any updates and changes of the Power BI templates, please mail to:

Template download

LS One Power BI version Works with LS One version Release date Comments and changes
2022 - 2.5 2022 February 2022 Power BI 2.5 - Release notes
2021 - 2.4 2021 and later 7th April 2021 Power BI 2.4 - Release notes
2020.1 - 2.3 2020.1 and later 10th November 2020 Power BI 2.3 - Release notes
2019 - 2.2 2019 and later 10th June 2020 Power BI 2.2 - Release notes
2017.2 - 2.2 2017.2 and later 10th June 2020 Power BI 2.2 - Release notes
2019 - 2.1 2019 and later 11th June 2019 Release notes for version 2.1
2017.2 - 2.1 2017.2 and later 11th June 2019 Release notes for version 2.1
2019 - 2.0 2019 and later 5th February 2019 Read release notes here
2017.2 - 2.0 2017.2 and later 5th February 2019 Read release notes here
2017.2 - 1.3 Beta 2017.2 and later 21st December 2018 Read release notes here
2017.2 - 1.2 Beta 2017.2 and later 12th October 2018 Read release notes here

2017.2 - 1.1 Beta

2017.2 official release

Build number:
2017.2 9.11.2017.8929

August 2018 BARCODEITEMID column commented out of Barcode query

2017.2 - 1.0 Beta

2017.2 hotfix and onwards

Build number:
2017.2 9.11.2017.9799

August 2018 This version was not officially released but provided a fix to some partners and is included in the devpack

 

Updated: January 2019
Version: LS One 2017.2